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
|
good questions
ReplyDelete