Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
Correct Answer: A. a relational operation that filters rows based on a condition
Explanation:
This statement is correct because selection operation means that a relational operation that filters rows based on a condition.
Choose an option to check your answer.
Correct Answer: B. a relational operation that filters rows based on a condition
Explanation:
selection operation is used in Advanced DBMS because a relational operation that filters rows based on a condition.
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: 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 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: 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: 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: 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: 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: A. the DBMS manages pages between disk and memory to reduce I/O cost
Explanation:
This statement is correct because buffer management means that the DBMS manages pages between disk and memory to reduce I/O cost.
Choose an option to check your answer.
Correct Answer: A. the DBMS manages pages between disk and memory to reduce I/O cost
Explanation:
buffer management is used in Advanced DBMS because the DBMS manages pages between disk and memory to reduce I/O cost.
Choose an option to check your answer.
Correct Answer: D. the DBMS manages pages between disk and memory to reduce I/O cost
Explanation:
The correct answer explains buffer management in the context of Physical Design and Tuning.
