Home »
MCQs »
DBMS MCQs
DBMS Estimating Query Cost MCQs
DBMS Estimating Query Cost MCQs: This section contains multiple-choice questions and answers on Estimating Query Cost in DBMS.
Submitted by Anushree Goswami, on May 07, 2022
1. Calculating the net estimated cost of any plan requires determining the cost of each operation included in the plan and combining the estimated costs to obtain the net estimated cost.
- Revenue Costs
- Eligible Costs
- Estimated Costs
- None
Answer: C) Estimated Costs
Explanation:
Calculating the net estimated cost of any plan requires determining the cost of each operation included in the plan and combining the estimated costs to obtain the net estimated cost.
2. The cost of an evaluation plan for a query is based on several factors, including:
- Accesses to the disk
- A CPU's time spent executing a query
- In distributed and parallel databases, communication costs are high.
- 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:
- Accesses to the disk
- A CPU's time spent executing a query
- In distributed and parallel databases, communication costs are high.
3. The number of blocks transferred from the disk, along with the number of disks seeks, are used to estimate the cost of a query evaluation plan.
- Query Estimation Plan
- Query Evaluation Plan
- Query Exemption Plan
- None
Answer: B) Query Evaluation Plan
Explanation:
The number of blocks transferred from the disk, along with the number of disks seeks, are used to estimate the cost of a query evaluation plan.
4. To estimate the cost, we generally take the ___ case into account.
- Best
- Worst
- Medium
- None
Answer: B) Worst
Explanation:
To estimate the cost, we generally take the worst case into account.
5. To estimate the cost of the query ____, it is possible to determine the response time, i.e., the time it takes to execute the plan.
- Evaluation Time
- Query Time
- Plan Time
- Response Time
Answer: D) Response Time
Explanation:
To estimate the cost of the query evaluation plan, it is possible to determine the response time, i.e., the time it takes to execute the plan.
6. Response time depends on the contents of the buffer when the query begins its execution.
- Response
- Execution
- Plan
- Query
Answer: A) Response
Explanation:
Response time depends on the contents of the buffer when the query begins its execution.
7. With multiple disks present in a system, a question such as "How are disk accesses distributed between the disks?" affects response time.
- Single
- Double
- Triple
- Multiple
Answer: D) Multiple
Explanation:
With multiple disks present in a system, a question such as "How are disk accesses distributed between the disks?" affects response time.
8. The optimizers find that reducing the total resource ____ of the query plan is more important than minimizing response time for queries.
- Conclusion
- Consumption
- Contradiction
- Conviction
Answer: B) Consumption
Explanation:
The optimizers find that reducing the total resource consumption of the query plan is more important than minimizing response time for queries.
9. It's a good idea to minimize the resources used to access the disk or use the extra resources when estimating the cost of a query evaluation plan.
- Maximize
- Minimize
- Mediumize
- None
Answer: B) Minimize
Explanation:
It's a good idea to minimize the resources used to access the disk or use the extra resources when estimating the cost of a query evaluation plan.
10. As long as you don't have an in-depth understanding of how the data is presented on the ____, it's hard to estimate.
- Disk
- Depth
- Data
- None
Answer: A) Disk
Explanation:
As long as you don't have an in-depth understanding of how the data is presented on the disk, it's hard to estimate.
ADVERTISEMENT
ADVERTISEMENT