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. 5 In the context of query optimization, what does the term “selectivity” mean?
a) The percentage of disk space used by the table.
b) The speed at which records are accessed.
c) The fraction of records that satisfy a condition.
d) The order in which records are stored.
Answer: c