Q. 1 Query optimization is primarily concerned with:
a) Designing the database schema.
b) Choosing the best way to execute a given query.
c) Increasing storage space.
d) Ensuring ACID properties.
Answer: b
Q. 2 Which phase of a DBMS translates a high-level query into a low-level query?
a) Normalization phase
b) Transaction phase
c) Query compilation phase
d) Disk scheduling phase
Answer: c