Saturday, 24 March 2018

DBMS general quiz 3

General Quiz in DBMS - TRUE / FALSE questions


1. Triggers can operate on insertion, deletion, and updates.
    TRUE
    FALSE

2. A user application executes a database Trigger by invoking “RUN TRIGGER triggername”.
    TRUE
    FALSE

3. Secondary storage is volatile.
    TRUE
    FALSE

4. Seek time is part of the disk latency time. case, while "bag semantics" requires additional work.
    TRUE
    FALSE

5. When an index is clustered it requires that the data records are sorted in the search key order of the index.
    TRUE
    FALSE

6. B+ trees can include duplicate keys.
    TRUE
    FALSE

7. When a sparse index is used, each record must have an entry in the index.
    TRUE
    FALSE

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

9. Spanned records refer to records that are longer than blocks and therefore are broken into fragments.
    TRUE
    FALSE

10. In SQL, without GROUP BY, we cannot use HAVING.
    TRUE
    FALSE

Go to TRUE/FALSE general quizzes page


Go to DBMS online quizzes page



dbms quiz to solve, database quiz with answers, try and score in database quiz, true or false questions in dbms, interview questions in dbms
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...