Chapter 11 Query Processing and Optimization
State True/False
| 1. | True |
| 2. | True |
| 3. | True |
| 4. | True |
| 5. | True |
| 6. | True |
| 7. | True |
| 8. | True |
| 9. | True |
| 10. | True |
| 11. | True |
| 12. | True |
| 13. | True |
| 14. | True |
| 15. | True |
| 16. | True. |
Tick (✓) the Appropriate Answer
| 1. | (a) |
| 2. | (a) |
| 3. | () |
| 4. | (a) |
| 5. | (c) |
| 6. | (a) |
| 7. | (c) |
| 8. | (d) |
| 9. | (c) |
| 10. | (a) |
| 11. | (b) |
| 12. | (c) |
| 13. | (d) |
| 14. | (a) |
| 15. | (d) |
| 16. | (d) |
| 17. | (d) |
| 18. | (d) |
| 19. | (c) |
| 20. | (c) |
| 21. | (a). |
Fill in the Blanks
| 1. | High-level, execution plan |
| 2. | Query complication |
| 3. | Parses, syntax |
| 4. | Query processing |
| 5. | Syntax analyzer uses the grammar of SQL as input and the parser portion of the query processor |
| 6. | Algebraic expression (relational algebra query) |
| 7. | (a) Syntax analyser, (b) Query decomposer, (c) Query Optimizer (d) Query code generator |
| 8. | (a) Heuristic query optimisation, (b) Systematic estimation |
| 9. | Query optimizer |
| 10. | Query decomposer ... |
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.
