Can someone answer these Database questions? 1 - Transaction is a ____ unit of w
ID: 3842950 • Letter: C
Question
Can someone answer these Database questions?
1 - Transaction is a ____ unit of work that must be either entirely completed or aborted
2 - A consistent database state is ___
3 - _____ requires that all operations of a transaction be completed.
4 - _____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
5 - A single- user database system automatically ensures_____ of the database, because only one transaction is executed at a time.
6 - The ANSI standard that govern SQL database transactions. Transaction support is provided by two SQL statements____ and ROLLBACK.
7 - ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a COMMIT?
8 - The ANSI standard that govern SQL database transactions. Of the following events, which is defined by ANSI as being equivalent to a ROLLBACK?
9 - The implicit beginning of a transaction is ___
10 - The information stored in the ___ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program's adnormal termination, or a system failure such as a network discrepancy or a disk crash
11 - One of the three most common data integrity and consistency problem is ___.
12 - _____ occurs when a transaction accesses data before and after one or more other transactions finish working with such data.
13 - As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome.
14 - ___ are required to prevent another transaction form reading inconsistent data
15 - Lock_____ indicates the level of lock use.
16 - A ____lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.
Explanation / Answer
1 - Transaction is a logical unit of work that must be either entirely completed or aborted
2 - A consistent database state is one in which all data integrity constraints are satisfied
3. Atomicity
4. Isolation means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
5. serializability and isolation
6. The ANSI standard that govern SQL database transactions. Transaction support is provided by two SQL statements COMMIT and ROLLBACK.
7. Five SQL statements are executed.
8.The end of a program is successfully reached.
9 .When the first SQL statement is encountered
10. log
11 . lost updates
12.Inconsistent retrievals
13 . unrelated
14 LOCKS
15. Lock granularity indicates the level of lock use.
16. table-level
Thanks, please rate and provide feedback