Home » MCQs » DBMS MCQs » DBMS Estimating Query Cost MCQs

The cost of an evaluation plan for a query is based on several factors, including:

2. The cost of an evaluation plan for a query is based on several factors, including:

1. Accesses to the disk
2. A CPU's time spent executing a query
3. In distributed and parallel databases, communication costs are high.
4. All of the above

Answer: D) All of the above

Explanation:

The cost of an evaluation plan for a query is based on several factors, including:

1. Accesses to the disk
2. A CPU's time spent executing a query
3. In distributed and parallel databases, communication costs are high.