Multiple Choice
On the client side, the objective is to generate an SQL query that returns a correct answer in the least amount of time, using a minimum amount of resources at the server end. The activities required to achieve this goal are commonly referred to as _____ tuning.
A) client SQL
B) database SQL
C) SQL performance
D) DBMS performance
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The _ cache is used as a
Q10: To generate database object statistics manually, following
Q11: _ are ordered sets of values that
Q12: RAID systems use a single disk to
Q13: The purpose of an I/O operation is
Q15: A(n) _ tablestores the end-user data and
Q16: The primary factor in determining the most
Q17: The data cache caches system catalog data
Q18: Which of the following is the first
Q19: Bitmap indexes tend to use less space