Advanced Database Management System - Tutorials and Notes: True or False questions in DBMS with answers

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

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

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents