Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Computer 9 > Database concepts and MySQL > Flashcards

Database concepts and MySQL Flashcards

1
Q

What is a database?

A

It is an organized collection of information that can be stored or searched. The information is logically related.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the advantages of database?

A

The advantages of database are:
1. Reduces data redundancy (duplication)
2. Controls data inconsistency
3. Data sharing is possible
4. To ensure data security
5. Integrity can be maintained through database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the disadvantages of database?

A

The following are the disadvantages of database:
1. Security may be compromised without good controls
2. Integrity may be compromise without good controls
3. Extra hardware may be required
4. More memory is required
5. Extra software may be required
6. The system is likely to be complex.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is data inconsistency?

A

Multiple copies of the same data that don’t match, is called data inconsistency. Whenever the common data needs an edit (Ex: Change in address or phone number), the same needs to be edited at multiple places else it will lead to data inconsistency.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is data redundancy?

A

Same data is stored in multiple places which is time consuming and wastage of memory. The repetition of data is called as data redundancy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is DBMS?

A

Database management system is a software that allows us to create, define, and manipulate data in a database. Ex: Oracle of MySQL
The user interacts back in forth with DBMS and DMBS interacts back in forth with the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is RDBMS?

A

Relation Data Base Managment System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the database language?

A

The database language is SQL or Structured Query Language.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is Database Schema?

A

It is a design or skeleton of database that is used to represent structure, types of data that will be stored in rows and columns, constraints and relationship between tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are Data constraints?

A

Data constraints are restrictions on the table. They are defined when we create a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is Metadata/Data Dictionary?

A

Metadata is known as the data of the data or the database schema along with different constraints on the data stored by DBMS in dictionary is known as metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is a Database instance?

A

The situation where data is stored in the database at a particular moment of time is called an instance. An instance is also called a current state or database state. In a database, a database instance is used to define the complete database environment and its components.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is a Query?

A

A query is used to access data from the database so users have to write queries to retrieve or manipulate data form the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is data manipulation?

A

In a database we can manipulate data using three operations: Insertion, deletion and updation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is a data engine?

A

It is a underlying software component that is used to create various databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is a relational database model?

A

In a relational database model, the data is organized into tables (rows and columns). These tables are called relations. A row in a table represents a relationship among a set of values. In other words, relational database are sets of relational information stored in a table.

17
Q

What is a relation?

A

A table storing logically related data, all rows of the table are distinct.

18
Q

What is a domain?

A

This is a pool of values from which the actual value appearing in a given column can be drawn.

19
Q

What is a tuple?

A

A row of a relation. Also called record

20
Q

What is a attribute.

A

A column of a relation. Also called field.

21
Q

What is degree?

A

Refers to the number of attributes in a relation

22
Q

What is cardinality?

A

refers to the number or tuples in a relation.

23
Q

What is a key? What are the types of keys?

A

A key is a single or combination of attributes used to identify and establish relation between two tables. There are four types of keys:
1. Primary key
2. Candidate key
3. Alternate key
4. Foreign key

24
Q

What is primary key?

A

One or more attributes that can uniquely identify tuples in a relation.

25
Q

What is candidate key?

A

All attribute combinations in a relation that can serve as a primary key are candidates for it and hence ,called candidate key.

26
Q

What is alternate key?

A

A candidate key that is not a primary key is called a alternate key.

27
Q

What is MySQL

A

MySQL is a freely available, open source software RDBMS. Information is stored in tables. It provides features that support secure environment for storing, maintaining and accessing data. It is fast reliable, scalable alternative to many RDBMS today.

Computer 9 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions