DBMS general quiz and interview questions 4

General Quiz in DBMS - TRUE / FALSE questions

1. Logical and physical addresses are both representations for the database address.

TRUE
FALSE

2. Secondary indexes are always dense.

TRUE
FALSE

3. In B-trees, we sometimes need to have overflow blocks.

TRUE
FALSE

4. Dynamic hash tables support range queries. case, while "bag semantics" requires additional work.

TRUE
FALSE

5. Dynamic programming is a bottom-up method, where we consider only the best plan for each subexpression of the logical-query plan.

TRUE
FALSE

6. In undo logging, it is not always possible to recover some consistent state of a database system if the system crashes during recovery.

TRUE
FALSE

7. Two-phase locking prevents deadlocks.

TRUE
FALSE

8. Concurrency control by timestamps is superior to that by locks if most transactions are read-only.

TRUE
FALSE

9. In fixed-length records, a character field of type CHAR is NOT allowed.

TRUE
FALSE

10. Hash index is efficient in answering range queries, such as "finding products with price higher than 100".

TRUE
FALSE

Go to TRUE/FALSE general quizzes page

Score =

Correct answers: