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. 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: 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: 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: 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: 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: C. query plans are compared using estimated costs such as I/O, CPU, and cardinality
Explanation:
The correct answer explains cost-based optimization in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: A. an operation that combines rows from related tables based on a condition
Explanation:
This statement is correct because join operation means that an operation that combines rows from related tables based on a condition.
Choose an option to check your answer.
Correct Answer: B. an operation that combines rows from related tables based on a condition
Explanation:
join operation is used in Advanced DBMS because an operation that combines rows from related tables based on a condition.
Choose an option to check your answer.
Correct Answer: B. an operation that combines rows from related tables based on a condition
Explanation:
The correct answer explains join operation in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: D. a relational operation that selects specific columns
Explanation:
This statement is correct because projection operation means that a relational operation that selects specific columns.
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 relational operation that selects specific columns
Explanation:
The correct answer explains projection operation in the context of Query Processing.
