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: A. an attribute value must come from a permitted domain or range
Explanation:
domain constraint is used in Advanced DBMS because an attribute value must come from a permitted domain or range.
Choose an option to check your answer.
Correct Answer: B. a statement used to remove privileges from users or roles
Explanation:
This statement is correct because REVOKE statement means that a statement used to remove privileges from users or roles.
Choose an option to check your answer.
Correct Answer: C. adjusting schema, indexes, queries, and configuration to improve performance
Explanation:
The correct answer explains database tuning in the context of Physical Design and Tuning.
Choose an option to check your answer.
Correct Answer: C. an attribute value must come from a permitted domain or range
Explanation:
This statement is correct because domain constraint means that an attribute value must come from a permitted domain or range.
Choose an option to check your answer.
Correct Answer: A. a virtual table derived from one or more base tables
Explanation:
The correct answer explains view in the context of Database Administration.
Choose an option to check your answer.
Correct Answer: B. adjusting schema, indexes, queries, and configuration to improve performance
Explanation:
database tuning is used in Advanced DBMS because adjusting schema, indexes, queries, and configuration to improve performance.
Choose an option to check your answer.
Correct Answer: D. granting users permitted operations on database objects
Explanation:
The correct answer explains authorization in the context of Integrity and Security.
Choose an option to check your answer.
Correct Answer: C. a virtual table derived from one or more base tables
Explanation:
view is used in Advanced DBMS because a virtual table derived from one or more base tables.
Choose an option to check your answer.
Correct Answer: C. adjusting schema, indexes, queries, and configuration to improve performance
Explanation:
This statement is correct because database tuning means that adjusting schema, indexes, queries, and configuration to improve performance.
Choose an option to check your answer.
Correct Answer: D. granting users permitted operations on database objects
Explanation:
authorization is used in Advanced DBMS because granting users permitted operations on database objects.
Choose an option to check your answer.
Correct Answer: C. a virtual table derived from one or more base tables
Explanation:
This statement is correct because view means that a virtual table derived from one or more base tables.
Choose an option to check your answer.
Correct Answer: A. normalization reduces redundancy but may require joins that affect performance
Explanation:
The correct answer explains normalization trade-off in the context of Physical Design and Tuning.
