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 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: C. a data access method that reads all rows of a table
Explanation:
full table scan is used in Advanced DBMS because a data access method that reads all rows of a table.
Choose an option to check your answer.
Correct Answer: B. a data access method that reads all rows of a table
Explanation:
The correct answer explains full table scan in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: C. a data access method that uses an index to locate qualifying rows
Explanation:
This statement is correct because index scan means that a data access method that uses an index to locate qualifying rows.
Choose an option to check your answer.
Correct Answer: B. a data access method that uses an index to locate qualifying rows
Explanation:
index scan is used in Advanced DBMS because a data access method that uses an index to locate qualifying rows.
Choose an option to check your answer.
Correct Answer: A. a data access method that uses an index to locate qualifying rows
Explanation:
The correct answer explains index scan in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: D. a plan showing physical operations chosen to execute a query
Explanation:
This statement is correct because query execution plan means that a plan showing physical operations chosen to execute a query.
Choose an option to check your answer.
Correct Answer: A. a plan showing physical operations chosen to execute a query
Explanation:
query execution plan is used in Advanced DBMS because a plan showing physical operations chosen to execute a query.
Choose an option to check your answer.
Correct Answer: A. a plan showing physical operations chosen to execute a query
Explanation:
The correct answer explains query execution plan in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: B. the optimizer estimates how many rows an operation will produce
Explanation:
This statement is correct because cardinality estimation means that the optimizer estimates how many rows an operation will produce.
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.
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.
