Quiz dossier / Database Technology

DBT: 9 Query Optimization

Practice questions on parsing and preprocessing, logical and physical query optimization, cardinality estimation, statistics, and Selinger-style dynamic programming.

30 questionsEstimated 95 min0 flagged

Session status

Draft

Answered: 0/30
Score: 0/30

Question 1

1 point(s)

Which task is performed by the Parser, but NOT by the Preprocessor?

A. Resolving virtual views into base relations.

B. Checking if the specified attributes exist in the schema.

C. Converting query text into a parse tree according to a grammar.

D. Checking if the types for comparison operators are correct.