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: C. the DBMS translates, validates, optimizes, and executes a database query
Explanation:
The correct answer explains query processing in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: D. query plans are compared using estimated costs such as I/O, CPU, and cardinality
Explanation:
cost-based optimization is used in Advanced DBMS because query plans are compared using estimated costs such as I/O, CPU, and cardinality.
Choose an option to check your answer.
Correct Answer: A. a data access method that reads all rows of a table
Explanation:
This statement is correct because full table scan means that a data access method that reads all rows of a table.
Choose an option to check your answer.
Correct Answer: A. database program logic for managing runtime errors gracefully
Explanation:
The correct answer explains exception handling in the context of Database Programming.
Choose an option to check your answer.
Correct Answer: B. the DBMS translates, validates, optimizes, and executes a database query
Explanation:
query processing is used in Advanced DBMS because the DBMS translates, validates, optimizes, and executes a database query.
Choose an option to check your answer.
Correct Answer: A. query plans are compared using estimated costs such as I/O, CPU, and cardinality
Explanation:
This statement is correct because cost-based optimization means that query plans are compared using estimated costs such as I/O, CPU, and cardinality.
Choose an option to check your answer.
Correct Answer: C. a saved database program that can contain SQL and procedural logic
Explanation:
The correct answer explains stored procedure in the context of Database Programming.
Choose an option to check your answer.
Correct Answer: D. database program logic for managing runtime errors gracefully
Explanation:
exception handling is used in Advanced DBMS because database program logic for managing runtime errors gracefully.
Choose an option to check your answer.
Correct Answer: B. the DBMS translates, validates, optimizes, and executes a database query
Explanation:
This statement is correct because query processing means that the DBMS translates, validates, optimizes, and executes a database query.
Choose an option to check your answer.
Correct Answer: D. rules such as pushing selections early are used to improve query plans
Explanation:
The correct answer explains heuristic optimization in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: B. a saved database program that can contain SQL and procedural logic
Explanation:
stored procedure is used in Advanced DBMS because a saved database program that can contain SQL and procedural logic.
Choose an option to check your answer.
Correct Answer: D. database program logic for managing runtime errors gracefully
Explanation:
This statement is correct because exception handling means that database program logic for managing runtime errors gracefully.
