Monday, 26 March 2018

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:

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