Database Systems: Concepts, Design and Applications

Tick (✓) the Appropriate Answer

1.	During the query processing, the syntax of the query is checked by parser. compiler. syntax checker. none of these.
2.	A query execution strategy is evaluated by access or execution plan. query tree. database catalog none of these.
3.	The query is parsed, validated, and optimised in the method called static query optimization. recursive query optimization. dynamic query optimization. repetitive query optimization.
4.	The first phase of query processing is decomposition. restructuring. analysis. none of these.
5.	In which phase of the query processing is the query lexically and syntactically analysed using parsers to find out any syntax errors? normalization. semantic analysis. analysis. all of these.
6.	Which of the following represents ...