Saturday, 31 March 2018

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

No comments:

Post a Comment

Important properties of two phase locking protocol and its variants

Important properties of two phase locking protocol and its variants Properties of     2PL Serializability  2PL ensures co...