Monday, 15 February 2016

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



No comments:

Post a Comment

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...