LIS3781 Exam 1
Study online at https://quizlet.com/_6ufmob
1. A transaction is a ____ unit of work that must be logical
either entirely completed or aborted.
2. A consistent database is ____. One in which all
data integrity con-
straints are satis-
fied
3. ____ requires that all operations of a transaction be atomicity
completed.
4. ____ means that data used during the execution of a isolation
transaction cannot be used by a second transaction
until the first one is completed.
5. All transactions must display ____. atomicity, durabil-
ity, consistency,
isolation, and seri-
alizability
6. A single-user database system automatically en- serializability and
sures ____ of the database, because only one trans- isolation
action is executed at a time.
7. The ANSI has defined standards that govern SQL COMMIT
database transactions. Transaction support is provid-
ed by two SQL statements: ____ and ROLLBACK.
8. ANSI defines four events that signal the end of a The end of a pro-
transaction. Of the following events, which is defined gram is success-
by ANSI as being equivalent to a COMMIT? fully reached.
9. ANSI defines four events that signal the end of a The program is
transaction. Of the following events, which is defined abnormally termi-
by ANSI as being equivalent to a ROLLBACK? nated.
10. The implicit beginning of a transaction is ____. (That When the first
is, according to the ANSI SQL standard, when does a SQL statement is
transaction begin?) encountered
, LIS3781 Exam 1
Study online at https://quizlet.com/_6ufmob
11. The information stored in the ____ is used by the transaction log
DBMS for a recovery requirement triggered by a
ROLLBACK statement, a program's abnormal termi-
nation, or a system failure such as a network discrep-
ancy or a disk crash.
12. One of the three most common data integrity and lost updates
consistency problems is ____.
13. As long as two transactions, T1 and T2, access ____ unrelated
data, there is no conflict, and the order of execution
is irrelevant to the final outcome.
14. A ____ lock prevents the use of any tables in the data- database-level
base from one transaction while another transaction
is being processed.
15. ____ are required to prevent another transaction from Locks
reading inconsistent data.
16. The ____ manager is responsible for assigning and Lock
policing the locks used by the transactions.
17. Lock ____ indicates the level of lock use. granularity
18. A ____ lock locks the entire table preventing access table-level
to any row by a transaction while another transaction
is using the table.
19. A ____ lock locks the entire diskpage. page-level
20. A ____ lock allows concurrent transactions to access row-level
different rows of the same table.
21. A system table space, a user data table space, an file groups
index table space, and a temporary table space are
examples of _____.
22. table space
Study online at https://quizlet.com/_6ufmob
1. A transaction is a ____ unit of work that must be logical
either entirely completed or aborted.
2. A consistent database is ____. One in which all
data integrity con-
straints are satis-
fied
3. ____ requires that all operations of a transaction be atomicity
completed.
4. ____ means that data used during the execution of a isolation
transaction cannot be used by a second transaction
until the first one is completed.
5. All transactions must display ____. atomicity, durabil-
ity, consistency,
isolation, and seri-
alizability
6. A single-user database system automatically en- serializability and
sures ____ of the database, because only one trans- isolation
action is executed at a time.
7. The ANSI has defined standards that govern SQL COMMIT
database transactions. Transaction support is provid-
ed by two SQL statements: ____ and ROLLBACK.
8. ANSI defines four events that signal the end of a The end of a pro-
transaction. Of the following events, which is defined gram is success-
by ANSI as being equivalent to a COMMIT? fully reached.
9. ANSI defines four events that signal the end of a The program is
transaction. Of the following events, which is defined abnormally termi-
by ANSI as being equivalent to a ROLLBACK? nated.
10. The implicit beginning of a transaction is ____. (That When the first
is, according to the ANSI SQL standard, when does a SQL statement is
transaction begin?) encountered
, LIS3781 Exam 1
Study online at https://quizlet.com/_6ufmob
11. The information stored in the ____ is used by the transaction log
DBMS for a recovery requirement triggered by a
ROLLBACK statement, a program's abnormal termi-
nation, or a system failure such as a network discrep-
ancy or a disk crash.
12. One of the three most common data integrity and lost updates
consistency problems is ____.
13. As long as two transactions, T1 and T2, access ____ unrelated
data, there is no conflict, and the order of execution
is irrelevant to the final outcome.
14. A ____ lock prevents the use of any tables in the data- database-level
base from one transaction while another transaction
is being processed.
15. ____ are required to prevent another transaction from Locks
reading inconsistent data.
16. The ____ manager is responsible for assigning and Lock
policing the locks used by the transactions.
17. Lock ____ indicates the level of lock use. granularity
18. A ____ lock locks the entire table preventing access table-level
to any row by a transaction while another transaction
is using the table.
19. A ____ lock locks the entire diskpage. page-level
20. A ____ lock allows concurrent transactions to access row-level
different rows of the same table.
21. A system table space, a user data table space, an file groups
index table space, and a temporary table space are
examples of _____.
22. table space
