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: B. the DBMS chooses an efficient execution plan for a query
Explanation:
The correct answer explains query optimization in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: D. rules such as pushing selections early are used to improve query plans
Explanation:
heuristic optimization is used in Advanced DBMS because rules such as pushing selections early are used to improve query plans.
Choose an option to check your answer.
Correct Answer: B. a saved database program that can contain SQL and procedural logic
Explanation:
This statement is correct because stored procedure means that a saved database program that can contain SQL and procedural logic.
Choose an option to check your answer.
Correct Answer: D. a statement such as COMMIT or ROLLBACK that manages transaction completion
Explanation:
The correct answer explains transaction control statement in the context of Database Programming.
Choose an option to check your answer.
Correct Answer: A. the DBMS chooses an efficient execution plan for a query
Explanation:
query optimization is used in Advanced DBMS because the DBMS chooses an efficient execution plan for a query.
Choose an option to check your answer.
Correct Answer: A. rules such as pushing selections early are used to improve query plans
Explanation:
This statement is correct because heuristic optimization means that rules such as pushing selections early are used to improve query plans.
Choose an option to check your answer.
Correct Answer: A. a database program that automatically executes in response to specified events
Explanation:
The correct answer explains trigger in the context of Database Programming.
Choose an option to check your answer.
Correct Answer: A. the DBMS chooses an efficient execution plan for a query
Explanation:
This statement is correct because query optimization means that the DBMS chooses an efficient execution plan for a query.
Choose an option to check your answer.
Correct Answer: A. the optimizer estimates how many rows an operation will produce
Explanation:
The correct answer explains cardinality estimation in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: B. a database program that automatically executes in response to specified events
Explanation:
trigger is used in Advanced DBMS because a database program that automatically executes in response to specified events.
Choose an option to check your answer.
Correct Answer: A. a relational operation that filters rows based on a condition
Explanation:
The correct answer explains selection operation in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: C. the optimizer estimates how many rows an operation will produce
Explanation:
cardinality estimation is used in Advanced DBMS because the optimizer estimates how many rows an operation will produce.
