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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question