COSC 3380 FINAL EXAM QUESTIONS
WITH 100% VERIFIED ANSWERS
\.An __________ is written in the log whenever an update is reversed during a
rollback. - ANSWERS✔-undo
\.Whenever deadlock occurs, a cycle of dependent transactions always exists. -
ANSWERS✔-True
\.With a hot backup, as a transaction executes against the primary database -
ANSWERS✔-Log records are sent to the secondary database
\.Is the schedule
T1:R(x), T2:W(x), T2: commit, T1: W(x), T1: commit, T3: R(x), T3: commit
strict? - ANSWERS✔-Yes
\.A list of active transactions appear in a __________ record. - ANSWERS✔-
checkpoint
\.Which two-phase locking technique results in the longest wait times for
concurrent transactions? - ANSWERS✔-Rigorous
, \.One transaction can hold an exclusive lock while other transactions hold shared
locks on the same row. - ANSWERS✔-False
\.MySQL with InnoDB suspends processing during a checkpoint and restarts after
a checkpoint record is written to log. - ANSWERS✔-False
\.After a rollback, the database restarts a transaction - ANSWERS✔-Sometimes
\.CHECKPOINT statement syntax is specified in the SQL standard - ANSWERS✔-
False
\.During the undo phase, the recovery system reads the log in reverse and stops
at: - ANSWERS✔-The start record for the last transaction in the active transaction
list
\.A bank stores checking account data in a database. The bank stores account
owner data in a file on a different computer. A database transaction creates a new
owner in the file and assigns the owner to a checking account in the database.
The transaction is always Atomic. - ANSWERS✔-False
\.Deadlock can be spotted by looking for which of the following in the wait-for
graph? - ANSWERS✔-a cycle
\.Select the ACID property violated in the following example:
WITH 100% VERIFIED ANSWERS
\.An __________ is written in the log whenever an update is reversed during a
rollback. - ANSWERS✔-undo
\.Whenever deadlock occurs, a cycle of dependent transactions always exists. -
ANSWERS✔-True
\.With a hot backup, as a transaction executes against the primary database -
ANSWERS✔-Log records are sent to the secondary database
\.Is the schedule
T1:R(x), T2:W(x), T2: commit, T1: W(x), T1: commit, T3: R(x), T3: commit
strict? - ANSWERS✔-Yes
\.A list of active transactions appear in a __________ record. - ANSWERS✔-
checkpoint
\.Which two-phase locking technique results in the longest wait times for
concurrent transactions? - ANSWERS✔-Rigorous
, \.One transaction can hold an exclusive lock while other transactions hold shared
locks on the same row. - ANSWERS✔-False
\.MySQL with InnoDB suspends processing during a checkpoint and restarts after
a checkpoint record is written to log. - ANSWERS✔-False
\.After a rollback, the database restarts a transaction - ANSWERS✔-Sometimes
\.CHECKPOINT statement syntax is specified in the SQL standard - ANSWERS✔-
False
\.During the undo phase, the recovery system reads the log in reverse and stops
at: - ANSWERS✔-The start record for the last transaction in the active transaction
list
\.A bank stores checking account data in a database. The bank stores account
owner data in a file on a different computer. A database transaction creates a new
owner in the file and assigns the owner to a checking account in the database.
The transaction is always Atomic. - ANSWERS✔-False
\.Deadlock can be spotted by looking for which of the following in the wait-for
graph? - ANSWERS✔-a cycle
\.Select the ACID property violated in the following example:
