DBMS- Query, Transaction and Serurity Management Questions and Answers

Practice Mode
Showing 10 of 16 questions
Q11
Usually, heuristic rules are used in the form of query tree or query graph data structure.
  • A TRUE
  • B FALSE
Answer: Option A
Q12
The heuristic optimization algorithm utilize some of the transformation rules to tranform an initial query tree into an optimised and efficiently executable query tree.
  • A TRUE
  • B FALSE
Answer: Option A
Q13
The emphasis of cost minimisation depends on  the size and type of database applications.
  • A TRUE
  • B FALSE
Answer: Option A
Q14
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).
  • A TRUE
  • B FALSE
Answer: Option A
Q15
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q16
Combining operations into a pipeline eliminates the cost of reading and writting temporary relations.
  • A TRUE
  • B FALSE
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test