Review Questions
| 1. | What do you mean by the term query processing? What are its objectives? |
| 2. | What are the typical phases of query processing? With a neat sketch discuss these phases in high-level query processing. |
| 3. | Discuss the reasons for converting SQL queries into relational algebra queries before query optimization is done. |
| 4. | What is syntax analyser? Explain with an example. |
| 5. | What is the objective of query decomposer? What are the typical phases of query decomposition? Describe these phases with a neat sketch. |
| 6. | What is a query execution plan? |
| 7. | What is query optimization? Why is it needed? |
| 8. | With a detailed block diagram, explain the function of query optimization. |
| 9. | What is meant by the term heuristic optimization? Discuss the main heuristics ... |
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
