MCQ Collection
Advance Database Management Systems MCQs
Practice Advance Database Management Systems questions with answers and explanations.
Choose an option to check your answer.
Correct Answer: C. BLOBs and CLOBs are used to store large binary or character data
Explanation:
This statement is correct because large object management means that BLOBs and CLOBs are used to store large binary or character data.
Choose an option to check your answer.
Correct Answer: D. an index built on a non-ordering search key to speed up lookups
Explanation:
The correct answer explains secondary index in the context of File Organization.
Choose an option to check your answer.
Correct Answer: A. atomicity, consistency, isolation, and durability define reliable transaction behavior
Explanation:
ACID properties is used in Advanced DBMS because atomicity, consistency, isolation, and durability define reliable transaction behavior.
Choose an option to check your answer.
Correct Answer: C. transactions execute one after another without interleaving operations
Explanation:
This statement is correct because serial schedule means that transactions execute one after another without interleaving operations.
Choose an option to check your answer.
Correct Answer: B. records are placed wherever space is available, without ordering by a key
Explanation:
The correct answer explains heap file organization in the context of File Organization.
Choose an option to check your answer.
Correct Answer: C. an index built on a non-ordering search key to speed up lookups
Explanation:
secondary index is used in Advanced DBMS because an index built on a non-ordering search key to speed up lookups.
Choose an option to check your answer.
Correct Answer: A. atomicity, consistency, isolation, and durability define reliable transaction behavior
Explanation:
This statement is correct because ACID properties means that atomicity, consistency, isolation, and durability define reliable transaction behavior.
Choose an option to check your answer.
Correct Answer: C. an interleaved schedule produces the same effect as some serial schedule
Explanation:
The correct answer explains serializable schedule in the context of Transactions.
Choose an option to check your answer.
Correct Answer: C. records are placed wherever space is available, without ordering by a key
Explanation:
heap file organization is used in Advanced DBMS because records are placed wherever space is available, without ordering by a key.
Choose an option to check your answer.
Correct Answer: C. an index built on a non-ordering search key to speed up lookups
Explanation:
This statement is correct because secondary index means that an index built on a non-ordering search key to speed up lookups.
Choose an option to check your answer.
Correct Answer: D. a transaction is treated as all-or-nothing
Explanation:
The correct answer explains atomicity in the context of Transactions.
Choose an option to check your answer.
Correct Answer: B. an interleaved schedule produces the same effect as some serial schedule
Explanation:
serializable schedule is used in Advanced DBMS because an interleaved schedule produces the same effect as some serial schedule.
