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.