1. Database tuning must be done _______.
A. During the design phase.
B. Before any development is complete.
C. During Construction Phase
D. None of the above
Answer: A, B

2. A materialized views allows______.
A. Physical copy of table data.
B. Logical copy of table data
C. Both of the above
D. None of the above
Answer: A

3. The quality of SQL code depends completely on_____.
A. The quality of database model design.
B. The quantity of database model
C. None of the above
D. Both of the above
Answer: A

4. Which are correct? [Choose two]
A. Database model design supports SQL code.
B. SQL code supports application.
C. None of the above
D. All of the above
Answer: A, B

5. What are the advantages for using shorter alias name at table?
A. SQL code more easily readable.
B. Having to make future changes.
C. Less prone to error.
D. Easier to tune properly & easier to handle.
E. None of the above
Answer: A, B, C, D

6. The where clause can be used either to ______?
A. Include wanted records or exclude unwanted records or both.
B. Exclude wanted records or include unwanted or both
C. All of the above
D. None of the above
Answer: A

7. Which are true for “Like” operator?
A. Usually involves a full scan of a table & ignore indexing.
B. Extremely inefficient searching for a small no. of records.
C. All of the above

Answer: C