Home » MCQs » DBMS MCQs » DBMS Query Processing MCQs

What is TRUE about Query Optimization?

23. What is TRUE about Query Optimization?

1. The cost of evaluating a query can vary depending on its type.
2. The evaluation plan is built by the system, so the user need not focus on writing their query efficiently.
3. An efficient query evaluation plan is generated by a database system, which minimizes its costs.
4. All of the above

Answer: D) All of the above

Explanation:

In case of Query Optimization -

1. The cost of evaluating a query can vary depending on its type.
2. The evaluation plan is built by the system, so the user need not focus on writing their query efficiently.
3. An efficient query evaluation plan is generated by a database system, which minimizes its costs.