DBMS-Query Processing and Optimization Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q11
Which of the following cost is the most important cost component to be cosnsidered during the
  • A memory uses cost
  • B secondary storatte access cost.
  • C communication cost
  • D all of these.
Answer: Option D
Q12
Usually, heuristic rules are used in the form of
  • A query tree.
  • B query graph data structure.
  • C both (a) and (b)
  • D either (a) or (b)
Answer: Option D
Q13
The emphasis of cost minimization depends on the
  • A size of database applications
  • B type of database applications
  • C both (a) and (b)
  • D none of these
Answer: Option C
Q14
The success of estimating size and cost of intermediate relational algebra opeations depends on the emphasis of cost minimization depends on the
  • A amount of statistical data information stored with the DBMS
  • B accuracy of stastical data information stored with the DBMS
  • C both (a) and (b)
  • D none of these
Answer: Option C
Q15
Which of the following query processing method is more efficient ?
  • A pipelining
  • B materialization
  • C tunnelling
  • D none of these
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