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. a rule that preserves correctness and validity of database data
Explanation:
integrity constraint is used in Advanced DBMS because a rule that preserves correctness and validity of database data.
Choose an option to check your answer.
Correct Answer: B. verifying the identity of a user or application
Explanation:
This statement is correct because authentication means that verifying the identity of a user or application.
Choose an option to check your answer.
Correct Answer: A. a stored query result that can be refreshed to improve performance
Explanation:
The correct answer explains materialized view in the context of Database Administration.
Choose an option to check your answer.
Correct Answer: C. intentionally adding redundancy to improve read performance in selected cases
Explanation:
denormalization is used in Advanced DBMS because intentionally adding redundancy to improve read performance in selected cases.
Choose an option to check your answer.
Correct Answer: A. a rule that preserves correctness and validity of database data
Explanation:
This statement is correct because integrity constraint means that a rule that preserves correctness and validity of database data.
Choose an option to check your answer.
Correct Answer: D. assigning permissions to roles and assigning roles to users
Explanation:
The correct answer explains role management in the context of Database Administration.
Choose an option to check your answer.
Correct Answer: A. a stored query result that can be refreshed to improve performance
Explanation:
materialized view is used in Advanced DBMS because a stored query result that can be refreshed to improve performance.
Choose an option to check your answer.
Correct Answer: C. intentionally adding redundancy to improve read performance in selected cases
Explanation:
This statement is correct because denormalization means that intentionally adding redundancy to improve read performance in selected cases.
Choose an option to check your answer.
Correct Answer: C. primary key values must be unique and not null
Explanation:
The correct answer explains entity integrity in the context of Integrity and Security.
Choose an option to check your answer.
Correct Answer: A. assigning permissions to roles and assigning roles to users
Explanation:
role management is used in Advanced DBMS because assigning permissions to roles and assigning roles to users.
Choose an option to check your answer.
Correct Answer: C. a stored query result that can be refreshed to improve performance
Explanation:
This statement is correct because materialized view means that a stored query result that can be refreshed to improve performance.
Choose an option to check your answer.
Correct Answer: D. dividing a large table or index into smaller manageable pieces
Explanation:
The correct answer explains partitioning in the context of Physical Design and Tuning.
