database management systems interview questions 1

General Quiz in DBMS - TRUE / FALSE questions

1. Any candidate key of a relation is a super key for that relation.

TRUE
FALSE

2. All attributes of a relation together form a super key for the relation.

TRUE
FALSE

3. A relation decomposition is not always lossless.

TRUE
FALSE

4. One weakness of triggers is that they can only be activated for insertion and update operations case, while "bag semantics" requires additional work.

TRUE
FALSE

5. The default policy for the foreign-key constraint sets the value of a foreign-key to null when the tuple of its referenced attribute gets deleted.

TRUE
FALSE

6. Join is one of the ve basic operation in relational algebra.

TRUE
FALSE

7. In a relation R(X, Y, Z, T), if XY --> Y Z then X --> Z.

TRUE
FALSE

8. The primary key of a relation may contain a NULL value as a value for their components.

TRUE
FALSE

9. Every isa relation in the ER model is one-one.

TRUE
FALSE

10. If a relation R is in 3NF, R is also in BCNF.

TRUE
FALSE

Go to TRUE/FALSE general quizzes page

Score =

Correct answers:

dbms quiz entity relationship model quiz normalization quiz ER multiple choice questions Normalization MCQ