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

____________________ describes a process on the server side that will properly configure the DBMS environment to respond to clients’ requests in the fastest way possible, while making optimum use of existing resources. [removed] a. User performance tuning [removed] b. Entity performance tuning [removed] c. DBMS performance tuning [removed] d. SQL performance tuning

Most performance-tuning activities focus on doing what to the number of I/O operations, which are much slower than reading data from the data cache?

[removed]a. maximizing 
[removed]b. replacing 
[removed]c. converting 
[removed]d. minimizing

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