Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
Correct Answer: C. a database program that automatically executes in response to specified events
Explanation:
This statement is correct because trigger means that a database program that automatically executes in response to specified events.
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: 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: B. a database object used to process query results row by row
Explanation:
The correct answer explains cursor in the context of Database Programming.
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: 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: A. a database object used to process query results row by row
Explanation:
cursor is used in Advanced DBMS because a database object used to process query results row by row.
Choose an option to check your answer.
Correct Answer: D. a relational operation that selects specific columns
Explanation:
The correct answer explains projection operation in the context of Query Processing.
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: B. a database object used to process query results row by row
Explanation:
This statement is correct because cursor means that a database object used to process query results row by row.
Choose an option to check your answer.
Correct Answer: C. a relational operation that selects specific columns
Explanation:
projection operation is used in Advanced DBMS because a relational operation that selects specific columns.
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.
