1. Which of the following best defines a database performance tuning?

Database performance tuning refers to a set of activities and procedures designed to reduce the response time of the database system

2. Which of the following is NOT a factor for better system performance?

ROM

3. Which of the following statements is false?

Static query optimization is a query optimization mode in which the access path to a database is predetermined at run time

4. Which of the following statements best defines a rule-based query optimization algorithm?

 A rule-based query optimization algorithm is a query optimization technique that uses preset rules and points to determine the best approach to execute a query

5. Which of the following is NOT a valid activity in the parsing phase of a query?

 Generate access plan

6. Which five components typically cause bottlenecks within the database?

RAM, CPU, Hard Disk, Network, and Application Code

7. Which of the following is not a valid index structure?

Sparse index

8. Which of the following is NOT a valid guideline for creating indexes?

Do not use indexes in large tables or tables with high sparsity

9. What does the acronym RAID stand for?

Redundant Array of Independent Disks

10. Which of the following best defines index-organized table (IOT)?

IOT is a table that stores end-user data and index data in consecutive locations on permanent storage

Chapter 11 Use It

Processing a SQL query

• The marketing manager needs the following:A list of all customers who placed a custom order.
• The order exceeded a specific dollar amount during the 4^th aurter of the previous year’s holiday season.

Identify the DBMS component at each point in the path of the SQL query’s process.

1. newtwork
2. Listener
3. User process
4. optimizer
5. Data cache
6. I/o requests
7. Data files

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG