Multiple Choice
Of the following events, which is defined by ANSI as being equivalent to a ROLLBACK?
A) Five SQL statements are executed.
B) The end of a program is successfully reached.
C) All changes are aborted and returned to a previous consistent state.
D) The database is shut down for maintenance.
Correct Answer:
Verified
Correct Answer:
Verified
Q24: The multiuser DBMS must implement controls to
Q25: _ are required to prevent another transaction
Q26: _ ensure that a disk physical failure
Q27: The _ occurs when two concurrent transactions,
Q28: Lock _ indicates the level of lock
Q30: The phenomenon of uncommitted data occurs when
Q31: The _ manager is responsible for assigning
Q32: A(n) _ lock exists when concurrent transactions
Q33: The _ approach to scheduling concurrent transactions
Q34: The serializable isolation level is the least