Quiz
Chapter 11 (T/F)
Questions in this quiz (15)
11. One of the main functions of a database system is to provide timely answers to end users.
- ATrue
- BFalse
22. Good database performance is easy to evaluate.
- ATrue
- BFalse
33. 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.
- ATrue
- BFalse
44. Good database performance starts with good database design.
- ATrue
- BFalse
55. DBMS implementations are typically similar in complexity to two-tier client/server configurations.
- ATrue
- BFalse
66. A data file can only contain rows from one single table.
- ATrue
- BFalse
77. The data cache caches system catalog data and the contents of the indexes.
- ATrue
- BFalse
88. The SQL cache stores the end-user written SQL.
- ATrue
- BFalse
99. To work with data, the DBMS must retrieve the data from permanent storage and place it in RAM.
- ATrue
- BFalse
1010. The purpose of an I/O operation is to move data to and from different computer components or de-vices.
- ATrue
- BFalse
1111. Working with data in the data cache is many times faster than working with data in the data files.
- ATrue
- BFalse
1212. Fully equivalent means that the optimized query results are always the same as the original query.
- ATrue
- BFalse
1313. The SQL execution activities are performed by the query optimizer.
- ATrue
- BFalse
1414. All transaction management commands are processed during the parsing and execution phases of query processing.
- ATrue
- BFalse
1515. Indexes do not facilitate join operations.
- ATrue
- BFalse
Information
- Description
- asdf Quiz on Chapter 11 (T/F), created by . . on 07/12/2016.
- Author
- . .
- Language
- English
- Views
- 61
- Tags
- Rating
- No ratings yet Rate this quiz