Test
Chapter 10 (T/F)
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (20)
11. Most real-world database transactions are formed by only one database request.
- AVerdadero
- BFalso
22. To ensure consistency of the database, every transaction must begin with the database in an
Unstable state.- AVerdadero
- BFalso
33. Although the DBMS is designed to recover a database to a previous consistent state when an interruption
prevents the completion of a required set of transactions, the transactions themselves are defined by the end user
or programmer and must be semantically correct.- AVerdadero
- BFalso
44. The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event.
- AVerdadero
- BFalso
55. Atomicity indicates the permanence of the database's consistent state.
- AVerdadero
- BFalso
66. Serializability means that data used during the execution of a transaction cannot be used by a second
transaction until the first one is completed.- AVerdadero
- BFalso
77. Incomplete or improper transactions can have a devastating effect on database integrity.
- AVerdadero
- BFalso
88. The multiuser DBMS must implement controls to ensure serializability and isolation of transactions, in addition
to atomicity and durability, in order to guard the database's consistency and integrity.- AVerdadero
- BFalso
99. Durability requires that all portions of the transaction must be treated as a single, logical unit of work in which all operations are applied and completed to produce a consistent database.
- AVerdadero
- BFalso
1010. The phenomenon of uncommitted data occurs when two transactions are executed concurrently and the first transaction is rolled back after the second transaction has already accessed the uncommitted data—thus violating the isolation property of transactions.
- AVerdadero
- BFalso
1111. The scheduler establishes the order in which the operations within concurrent transactions are executed
- AVerdadero
- BFalso
1212. In a page-level lock, the DBMS will lock an entire disk page
- AVerdadero
- BFalso
1313. A shared lock produces no conflict as long as all the concurrent transactions are read-write only.
- AVerdadero
- BFalso
1414. A field-level lock allows concurrent transactions to access the same row, as long as they require the use of different fields within that row
- AVerdadero
- BFalso
1515. A growing phase in a two-phase lock is when a transaction acquires all the required locks without locking any data.
- AVerdadero
- BFalso
1616. When using an optimistic approach, a transaction reads the database, executes the needed computations, and makes the updates to a private copy of the database values.
- AVerdadero
- BFalso
1717. An optimistic approach is based on the assumption that the majority of the database operations do not conflict.
- AVerdadero
- BFalso
1818. When using an optimistic approach, during the write phase, the transaction is validated to ensure that the changes made will not affect the integrity and consistency of the database.
- AVerdadero
- BFalso
1919. The transaction recovery write-ahead-log protocol ensures that transaction logs are always written before any database data are actually updated.
- AVerdadero
- BFalso
2020. The last step in the write-through technique recovery procedure is to identify the last checkpoint in the transaction log.
- AVerdadero
- BFalso
Información
- Descripción
- asdf Test sobre Chapter 10 (T/F), creado por . . el 07/12/2016.
- Autor
- . .
- Idioma
- English
- Visitas
- 47
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test