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: