O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required