Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
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: 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: B. atomicity, consistency, isolation, and durability define reliable transaction behavior
Explanation:
The correct answer explains ACID properties in the context of Transactions.
Choose an option to check your answer.
Correct Answer: A. an index using bit vectors, useful for low-cardinality attributes
Explanation:
This statement is correct because bitmap index means that an index using bit vectors, useful for low-cardinality attributes.
Choose an option to check your answer.
Correct Answer: A. an index using bit vectors, useful for low-cardinality attributes
Explanation:
bitmap index is used in Advanced DBMS because an index using bit vectors, useful for low-cardinality attributes.
Choose an option to check your answer.
Correct Answer: D. an index using bit vectors, useful for low-cardinality attributes
Explanation:
The correct answer explains bitmap index in the context of File Organization.
Choose an option to check your answer.
Correct Answer: D. a balanced tree index in which data pointers are commonly stored at leaf level
Explanation:
This statement is correct because B+ tree index means that a balanced tree index in which data pointers are commonly stored at leaf level.
Choose an option to check your answer.
Correct Answer: D. a balanced tree index in which data pointers are commonly stored at leaf level
Explanation:
B+ tree index is used in Advanced DBMS because a balanced tree index in which data pointers are commonly stored at leaf level.
Choose an option to check your answer.
Correct Answer: B. a balanced tree index in which data pointers are commonly stored at leaf level
Explanation:
The correct answer explains B+ tree index in the context of File Organization.
Choose an option to check your answer.
Correct Answer: C. an index that stores entries for some search key values, usually one per block
Explanation:
This statement is correct because sparse index means that an index that stores entries for some search key values, usually one per block.
Choose an option to check your answer.
Correct Answer: D. an index that stores entries for some search key values, usually one per block
Explanation:
sparse index is used in Advanced DBMS because an index that stores entries for some search key values, usually one per block.
Choose an option to check your answer.
Correct Answer: B. an index that stores entries for some search key values, usually one per block
Explanation:
The correct answer explains sparse index in the context of File Organization.
