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

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

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