Database management systems - Normalization and normal forms quiz

Database management system quiz - DBMS quiz with answers - DBMS multiple choice questions - Database normalization quiz - DBMS normalization process interview questions - Normalization and normal forms quiz in DBMS - Normal forms in Database interview questions

Normalization QUIZ

1. Assume that a relation R has the following properties. What is the normal form of R?             No multi-valued attributes             No partial key dependencies
(a) First Normal Form	(b) Second Normal Form
(c) Third Normal Form	(d) Boyce-Codd Normal Form
2. Assume that a relation R has the following properties. What is the normal form of R?             Has no partial key dependencies             Has multi-valued attributes
(a) First Normal Form	(b) Second Normal Form
(c) Third Normal Form	(d) None of the above
3. All functional dependencies must _________
(a) have attributes of the same table	(b) have a single attribute on its LHS
(c) have a single attribute on its RHS	(d) All of the above
4. Which one of the following is always a single-valued attribute?
(a) a person’s phone number	(b) a person’s address
(c) a person’s age	(d) a person’s car
Let R (A, B, C, D, E, F) be a relation with the functional dependencies A → B, A → C, CD → E, CD → F, B → E. Use this information to answer questions 5, 6, and 7.
5. Which of the following does not hold on R?
(a) A → E	(b) CD → EF
(c) AD → F	(d) B → CD
6. Which of the following is holding on R?
(a) A → C	(b) B → A
(c) CD → A	(d) C → D
7. Which of the following does not hold on R?
(a) BC → D	(b) AD → B
(c) BC → E	(d) ACD → BEF
8. A functional dependency that exist between two non-key attributes is called _____
(a) Non-transitive dependency	(b) Transitive dependency
(c) Partial transitive dependency	(d) None of the above
9. Assume that a relation R has the following properties. What is the normal form of R?             Has no multi-valued attributes             Has no partial key dependencies             Has attributes with atomic domains             Has transitive dependencies
(a) 1NF & 2NF	(b) 1NF, 2NF, & 3NF
(c) 1NF & 3NF	(d) BCNF
10. Assume a relation R with the following 3 attributes; one attribute as primary key, one attribute as foreign key and one non-key attribute. Also, none of them is multi-valued attribute. What is the maximum normal form R can be in?
(a) 1NF	(b) 2NF
(c) 3NF	(d) BCNF

Go to QUIZZ in Database / DBMS / Advanced DBMS page

Database management systems - basics and ER modelling quiz

Database management system quiz - DBMS quiz with answers - DBMS multiple choice questions - DBMS basics quiz - DBMS interview questions - ER modelling quiz in DBMS - ER modelling in Database interview questions

QUIZ

1. _________ attribute can uniquely identify a record (row/tuple) in a table (relation).
(a) Partial key	(b) Candidate key
(c) Foreign key	(d) All of the above
2. Which of the following is used to logically connect a table with the other?
(a) Super key	(b) Candidate key
(c) Unique key	(d) Primary key
3. One driver drives one or more cars, and one car is driven by one or more drivers. What type of relationship is this?
(a) One-to-one	(b) One-to-many
(c) Many-to-one	(d) Many-to-many
4. A customer can have one or more vehicles and a vehicle is owned by exactly one customer. What type of relationship exists between customer and vehicle?
(a) One-to-one from customer to vehicle	(b) One-to-many from customer to vehicle
(c) Many-to-one from customer to vehicle	(d) Many-to-many from customer to vehicle
5. A cricket player can play for exactly one team, and a team can consist of several players. What type of relationship exists between team and player from team to player?
(a) One-to-one	(b) One-to-many
(c) Many-to-one	(d) Many-to-many
6. __________ schema defines the view(s) of a relation to the end users.
(a) Conceptual schema	(b) External schema
(c) Physical schema	(d) Logical schema
7. What type of relationship would exist between Tourist entity set and Passport entity set?
(a) One-to-one	(b) One-to-many
(c) Many-to-one	(d) Many-to-many
8. If a strong entity set A of an ER diagram contains a multi-valued attribute, then which one of the following is true?
(a) Reducing A into relation must not contain that multi-valued attribute	(b) A separate relation has to be created for multi-valued attribute
(c) A cannot be in 1NF, if that multi-valued attribute is included with A.	(d) All of them are TRUE
9. An author can write many books, in turn, a book can be written by at most one author. What type of relationship would exist between Author and Book entity sets?
(a) One-to-one from Book to Author	(b) One-to-many from Author to Book
(c) Many-to-one from Book to Author	(d) Both (b) and (c)
10. A candidate key is a key _____________ .
(a) that uniquely identify any rows in a table.	(b) that is redundant
(c) that cannot uniquely identify any rows in a table.	(d) None of the above

Go to ER modeling quiz page

Go to QUIZZ in Database / DBMS / Advanced DBMS page

DBMS General - Quiz

Relational Database Design Quiz

1. In the relational modes, what do we mean by the term “Cardinality”?

Number of tuples
Number of attributes
Number of tables
Number of constraints

2. In relational algebra, Cartesian product is a ___________ operator?

Unary operator
Binary operator
Ternary operator
None of the above

3. Which of the following is an example of procedural language?

Relational calculus
Relational algebra
SQL
All of the above

4. ODBC stands for _________ .

Object Database Connectivity
Open Database Connectivity
Oracle Database Connectivity
Orient Database Connectivity

5. A database schema can be defined using which of the following languages?

DML
DCL
DDL
TCL

6. ________ is used as the defacto standard language to interact with the database.

SQL
DDL
NoSQL
None of the above

7. A Cartesian product of two relations is the same as their union. TRUE/FALSE.

TRUE
FALSE

8. Data independence means

Data is defined separately and not included in programs
Programs are not dependent on the physical attributes of data
Programs are not dependent on the logical attributes of data
Both B and C

9. Which of the following is used to represent the relationships between two relations (tables)?

Primary key
Secondary key
Foreign key
Surrogate key

10. The file organization that provides very fast access to any arbitrary record of a file is ___ .

Hashed file
Unordered file
Ordered file
Clustered file

Score =

Correct answers:

Entity Relationship Model Quiz

Relational model and Normalization Quiz

1. Cardinality in an ER or UML diagram can specify lower and upper limits to numbers of participants in a relationship. TRUE / FALSE?

TRUE
FALSE

2. An Attribute domain is a set of values that might be assigned to an attribute. TRUE/FALSE?

TRUE
FALSE

3. An entity that is existence-dependent on some other entity type is strong entity . TRUE/FALSE?

TRUE
FALSE

4. A Candidate key is an attribute or set of attributes that uniquely identifies individual occurrences of an entity type. TRUE/FALSE?

TRUE
FALSE

5. Degree of a relationship is always 1. TRUE/FALSE?

TRUE
FALSE

6. Relationships can’t have attributes . TRUE/FALSE?

TRUE
FALSE

7. A Composite key is a candidate key that consists of two or more attributes . TRUE/FALSE?

TRUE
FALSE

8. An ER diagram’s purpose is to support a user’s perception of the data and conceal the technical aspects associated with database design . TRUE/FALSE?

TRUE
FALSE

9. Entity Relationship diagram aims to facilitate database design. TRUE/FALSE?

TRUE
FALSE

10. In a one-to-many relationship, the entity that is on the one side of the relationship is called a parent entity. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers:

Structured Query Language Quiz

Relational model and Normalization Quiz

1. In a CREATE TABLE statement, each column/attribute must have a data type associated with it. TRUE / FALSE?

TRUE
FALSE

2. Referential integrity ensures that a value stored in the foreign key attribute matches a primary key attribute in the referred table. TRUE/FALSE?

TRUE
FALSE

3. A view is part of the external schema and is considered as an acceptable way to offer simpler tables with customized attribute names to the user. TRUE/FALSE?

TRUE
FALSE

4. A view can be referred to like a table in a SELECT. TRUE/FALSE?

TRUE
FALSE

5. Besides a shorthand reference to the table throughout the query, using an alias makes the query run much faster as a result. TRUE/FALSE?

TRUE
FALSE

6. Deleting from a view that is based on a natural join of its base tables is acceptable. TRUE/FALSE?

TRUE
FALSE

7. If both NOT NULL and UNIQUE integrity constraints are defined on an attribute, the designation implies that the attribute is a candidate key. TRUE/FALSE?

TRUE
FALSE

8. An INSERT requires the input values sequence to match the attribute sequence when the attributes are specified in the INSERT statement. TRUE/FALSE?

TRUE
FALSE

9. The SQL SELECT statement includes the sequence of steps to exectue a query besides the operations that the server uses to answer the query. TRUE/FALSE?

TRUE
FALSE

10. Triggers provide a mechanism to monitor specific changes to a table and perform additional actions based on the altered data. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers: