Chapter 10 (T/F)

Question 1

1. Most real-world database transactions are formed by only one database request.

Answer

true

Question 2

2. To ensure consistency of the database, every transaction must begin with the database in an
Unstable state.

Answer

true

Question 3

3. 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.

Answer

true

Question 4

4. The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event.

Answer

true

Question 5

5. Atomicity indicates the permanence of the database's consistent state.

Answer

true

Question 6

6. Serializability means that data used during the execution of a transaction cannot be used by a second
transaction until the first one is completed.

Answer

true

Question 7

7. Incomplete or improper transactions can have a devastating effect on database integrity.

Answer

true

Question 8

8. 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.

Answer

true

Question 9

9. 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.

Answer

true

Question 10

10. 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.

Answer

true

Question 11

11. The scheduler establishes the order in which the operations within concurrent transactions are executed

Answer

true

Question 12

12. In a page-level lock, the DBMS will lock an entire disk page

Answer

true

Question 13

13. A shared lock produces no conflict as long as all the concurrent transactions are read-write only.

Answer

true

Question 14

14. 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

Answer

true

Question 15

15. A growing phase in a two-phase lock is when a transaction acquires all the required locks without locking any data.

Answer

true

Question 16

16. 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.

Answer

true

Question 17

17. An optimistic approach is based on the assumption that the majority of the database operations do not conflict.

Answer

true

Question 18

18. 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.

Answer

true

Question 19

19. The transaction recovery write-ahead-log protocol ensures that transaction logs are always written before any database data are actually updated.

Answer

true

Question 20

20. The last step in the write-through technique recovery procedure is to identify the last checkpoint in the transaction log.

Answer

true

Chapter 10 (T/F)

Erstelle ein kostenloses Konto, um dieses Quiz zu beenden

Fragen in diesem Quiz (20)

Informationen

Feedback

Wie gefällt dir das neue Design?