Tick (✓) the Appropriate Answer

1.During the query processing, the syntax of the query is checked by
  1. parser.

  2. compiler.

  3. syntax checker.

  4. none of these.

2.A query execution strategy is evaluated by
  1. access or execution plan.

  2. query tree.

  3. database catalog

  4. none of these.

3.The query is parsed, validated, and optimised in the method called
  1. static query optimization.

  2. recursive query optimization.

  3. dynamic query optimization.

  4. repetitive query optimization.

4.The first phase of query processing is
  1. decomposition.

  2. restructuring.

  3. analysis.

  4. 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?
  1. normalization.

  2. semantic analysis.

  3. analysis.

  4. all of these.

6.Which of the following represents ...

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.