Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

What database statistics measurements are typical of environment resources?

A(n) _______________ optimizer uses sophisticated algorithms based on the statistics about the objects being accessed to determine the best approach to execute a query.

[removed]a. cost-based 
[removed]b. user-based 
[removed]c. rule-based 
[removed]d. query-based

You use ________________ to provide both performance improvement and fault tolerance, and a balance between them as part of DBMS performance tuning.

[removed]a. Optimizer mode 
[removed]b. RAID 
[removed]c. Sort cache 
[removed]d. None of these choices are correct.

Which of the following are recommendations you would make for managing the data files in a DBMS with many tables and indexes?

[removed]a. Put high-usage end-user tables in their own table spaces 
[removed]b. Evaluate the creation of indexes based on the access patterns 
[removed]c. Create independent data files for the system, indexes and user data table spaces 
[removed]d. All of these choices are correct.

Which of the following is an example of an optimizer hint used in standard SQL?

[removed]a. MULTI_ROWS 
[removed]b. NO_ROWS 
[removed]c. I_ROWS 
[removed]d. FIRST_ROWS

___________________ describes a process on the client side that will generate an SQL query to return the correct answer in the least amount of time, using the minimum amount of resources at the server end.

[removed]a. User performance tuning 
[removed]b. Database performance tuning 
[removed]c. SQL performance tuning 
[removed]d. Entity performance tuning