Multiple Choice
Of the following events, which is defined by ANSI as being equivalent to a COMMIT?
A) Five SQL statements are executed.
B) The end of a program is successfully reached.
C) The program is abnormally terminated.
D) The database is shut down for maintenance.
Correct Answer:
Verified
Correct Answer:
Verified
Q2: A field-level lock allows concurrent transactions to
Q3: ANSI has defined standards that govern SQL
Q4: A _ lock will lock the entire
Q5: The scheduler establishes the order in which
Q6: Uniqueness ensures that no equal time stamp
Q8: Atomicity indicates the permanence of the database's
Q9: A(n) _ specifically reserves access to the
Q10: The _ interleaves the execution of database
Q11: _-level locks are less restrictive than database-level
Q12: The _ rule states that only one