DBMS-Query Processing and Optimization
DBMS-Query Processing and Optimization
11. Which of the following cost is the most important cost component to be cosnsidered during the
- memory uses cost
- secondary storatte access cost.
- communication cost
- all of these.
12. Usually, heuristic rules are used in the form of
- query tree.
- query graph data structure.
- both (a) and (b)
- either (a) or (b)
13. The emphasis of cost minimization depends on the
- size of database applications
- type of database applications
- both (a) and (b)
- none of these
14. The success of estimating size and cost of intermediate relational algebra opeations depends on the emphasis of cost minimization depends on the
- amount of statistical data information stored with the DBMS
- accuracy of stastical data information stored with the DBMS
- both (a) and (b)
- none of these
15. Which of the following query processing method is more efficient ?
- pipelining
- materialization
- tunnelling
- none of these