Multiple Choice
To optimize queries, use simple columns or literals as operands in a conditional expression and avoid the use of conditional expressions with ____ whenever possible.
A) the WHERE clause
B) functions
C) the GROUP BY clause
D) Indexes
Correct Answer:
Verified
Correct Answer:
Verified
Q9: Generally, what will provide the best database
Q10: Which of the following is not a
Q11: Working with data in the data cache
Q12: Who developed QBE?<br>A)C.J. Date<br>B)E.F. Codd<br>C)M.M. Zloof<br>D)None of
Q13: Which of the following is IBM's first
Q14: Database statistics are stored in the system
Q15: Who developed Structured English Query Language?<br>A)E.F. Codd<br>B)D.
Q17: What is the expansion of QBE?<br>A)Query by
Q18: Which of the following is the operation
Q19: The majority of current database performance problems