Wednesday, 21 March 2018

True or False questions in DBMS with answers

General Quiz in DBMS


1. An extensible hash table always squares the number of buckets when it has to grow.
    TRUE
    FALSE

2. A Cartesian product of two relations is the same as their union. TRUE/FALSE.
    TRUE
    FALSE

3. Selection is a "tuple at a time" operation, while Union is a "full relation" operation.
    TRUE
    FALSE

4. From the perspective of query processing, "set semantics" of a union operation is the easy case, while "bag semantics" requires additional work.
    TRUE
    FALSE

5. In two pass algorithms based on hashing, for binary operations, all tuples that need to be considered together in the operation are in a pair of buckets with the same hash value.
    TRUE
    FALSE

6. According to dependency theory, it is always bad if a relation has more than one key.
    TRUE
    FALSE

7. "Pushing selections down" refers to the choice of processing selections "early" during query optimization, which is often advantageous because it means fewer tuples need to be manipulated in later steps.
    TRUE
    FALSE

8. If your schema is in 3NF but not in 4NF, then you probably need to revise it.
    TRUE
    FALSE

9. Among the "ACID" properties of a good database system, the "I" stands for "inexpensive".
    TRUE
    FALSE

10. In Redo logging, OUTPUTs are done "early", i.e., before commit.
    TRUE
    FALSE

Go to TRUE/FALSE general quizzes page


Go to DBMS MCQ for Engineering Students home page


Go to Solved Exercises in DBMS page



Score =

Correct answers:

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...