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: D. records are placed wherever space is available, without ordering by a key
Explanation:
This statement is correct because heap file organization means that records are placed wherever space is available, without ordering by a key.
Choose an option to check your answer.
Correct Answer: D. an index that has an entry for every search key value or record
Explanation:
The correct answer explains dense index in the context of File Organization.
Choose an option to check your answer.
Correct Answer: D. a transaction is treated as all-or-nothing
Explanation:
atomicity is used in Advanced DBMS because a transaction is treated as all-or-nothing.
Choose an option to check your answer.
Correct Answer: B. an interleaved schedule produces the same effect as some serial schedule
Explanation:
This statement is correct because serializable schedule means that an interleaved schedule produces the same effect as some serial schedule.
Choose an option to check your answer.
Correct Answer: C. records are stored in a sorted sequence according to a search key
Explanation:
The correct answer explains sequential file organization in the context of File Organization.
Choose an option to check your answer.
Correct Answer: B. an index that has an entry for every search key value or record
Explanation:
dense index is used in Advanced DBMS because an index that has an entry for every search key value or record.
Choose an option to check your answer.
Correct Answer: B. a transaction is treated as all-or-nothing
Explanation:
This statement is correct because atomicity means that a transaction is treated as all-or-nothing.
Choose an option to check your answer.
Correct Answer: D. a schedule can be transformed to a serial schedule by swapping non-conflicting operations
Explanation:
The correct answer explains conflict serializability in the context of Transactions.
Choose an option to check your answer.
Correct Answer: C. records are stored in a sorted sequence according to a search key
Explanation:
sequential file organization is used in Advanced DBMS because records are stored in a sorted sequence according to a search key.
Choose an option to check your answer.
Correct Answer: B. an index that has an entry for every search key value or record
Explanation:
This statement is correct because dense index means that an index that has an entry for every search key value or record.
Choose an option to check your answer.
Correct Answer: D. a transaction moves the database from one valid state to another valid state
Explanation:
The correct answer explains consistency in the context of Transactions.
Choose an option to check your answer.
Correct Answer: D. a schedule can be transformed to a serial schedule by swapping non-conflicting operations
Explanation:
conflict serializability is used in Advanced DBMS because a schedule can be transformed to a serial schedule by swapping non-conflicting operations.
