Test
Chapter 11 (T/F)
Preguntas del test (15)
11. One of the main functions of a database system is to provide timely answers to end users.
- AVerdadero
- BFalso
22. Good database performance is easy to evaluate.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
44. Good database performance starts with good database design.
- AVerdadero
- BFalso
55. DBMS implementations are typically similar in complexity to two-tier client/server configurations.
- AVerdadero
- BFalso
66. A data file can only contain rows from one single table.
- AVerdadero
- BFalso
77. The data cache caches system catalog data and the contents of the indexes.
- AVerdadero
- BFalso
88. The SQL cache stores the end-user written SQL.
- AVerdadero
- BFalso
99. To work with data, the DBMS must retrieve the data from permanent storage and place it in RAM.
- AVerdadero
- BFalso
1010. The purpose of an I/O operation is to move data to and from different computer components or de-vices.
- AVerdadero
- BFalso
1111. Working with data in the data cache is many times faster than working with data in the data files.
- AVerdadero
- BFalso
1212. Fully equivalent means that the optimized query results are always the same as the original query.
- AVerdadero
- BFalso
1313. The SQL execution activities are performed by the query optimizer.
- AVerdadero
- BFalso
1414. All transaction management commands are processed during the parsing and execution phases of query processing.
- AVerdadero
- BFalso
1515. Indexes do not facilitate join operations.
- AVerdadero
- BFalso
Información
- Descripción
- asdf Test sobre Chapter 11 (T/F), creado por . . el 07/12/2016.
- Autor
- . .
- Idioma
- English
- Visitas
- 61
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test