DBMS-Query Processing and Optimization Questions and Answers
DBMS Query Processing and Optimization is a crucial area of aptitude questions and answers with explanations for database exams and interviews. It focuses on how a DBMS translates SQL commands into executable steps, selects the best execution plan, and minimizes processing time. Concepts such as query parsing, optimization algorithms, and indexing are central to improving database performance. Companies like TCS, Infosys, and Cognizant often test these fundamentals in placement exams. Practicing database aptitude test practice online helps students develop a strong foundation in performance tuning and query optimization strategies.
DBMS-Query Processing and Optimization
Showing 10 of
15 questions
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