Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
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: 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: 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: 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: 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: 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: B. an index built on a file ordered by the primary key
Explanation:
This statement is correct because primary index means that an index built on a file ordered by the primary key.
Choose an option to check your answer.
Correct Answer: A. an index built on a file ordered by the primary key
Explanation:
primary index is used in Advanced DBMS because an index built on a file ordered by the primary key.
Choose an option to check your answer.
Correct Answer: B. an index built on a file ordered by the primary key
Explanation:
The correct answer explains primary index in the context of File Organization.
Choose an option to check your answer.
Correct Answer: D. related records that are often accessed together are stored near each other
Explanation:
This statement is correct because clustered file organization means that related records that are often accessed together are stored near each other.
Choose an option to check your answer.
Correct Answer: C. related records that are often accessed together are stored near each other
Explanation:
clustered file organization is used in Advanced DBMS because related records that are often accessed together are stored near each other.
Choose an option to check your answer.
Correct Answer: C. related records that are often accessed together are stored near each other
Explanation:
The correct answer explains clustered file organization in the context of File Organization.
