Chapter 11 (T/F)

1. One of the main functions of a database system is to provide timely answers to end users.

2. Good database performance is easy to evaluate.

3. All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

4. Good database performance starts with good database design.

5. DBMS implementations are typically similar in complexity to two-tier client/server configurations.

6. A data file can only contain rows from one single table.

7. The data cache caches system catalog data and the contents of the indexes.

8. The SQL cache stores the end-user written SQL.

9. To work with data, the DBMS must retrieve the data from permanent storage and place it in RAM.

10. The purpose of an I/O operation is to move data to and from different computer components or de-vices.

11. Working with data in the data cache is many times faster than working with data in the data files.

12. Fully equivalent means that the optimized query results are always the same as the original query.

13. The SQL execution activities are performed by the query optimizer.

14. All transaction management commands are processed during the parsing and execution phases of query processing.

15. Indexes do not facilitate join operations.