DBMS- Query, Transaction and Serurity Management
DBMS- Query, Transaction and Serurity Management
11. Usually, heuristic rules are used in the form of query tree or query graph data structure.
- TRUE
- FALSE
12. The heuristic optimization algorithm utilize some of the transformation rules to tranform an initial query tree into an optimised and efficiently executable query tree.
- TRUE
- FALSE
13. The emphasis of cost minimisation depends on the size and type of database applications.
- TRUE
- FALSE
14. The success of estimating size and cost of intermediate relational algebra operations depends on the amount and accuracy of the statistical data information stored with the database management system (DBMS).
- TRUE
- FALSE
15. The cost of materialised evaluation includes the cost of writing the result of each operation to the secondary storage and reading them back for the next operation.
- TRUE
- FALSE
16. Combining operations into a pipeline eliminates the cost of reading and writting temporary relations.
- TRUE
- FALSE