Monday, February 15, 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



1 comment:

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery