OMIS 452 Chapter 6 Questions with Correct Answers (Grade A+)
Question 1: Additional DBA responsibilities do not include ___ _. A) problem and error reporting B)
requests of changes to existing systems C) controlling database configuration D) maintaining
appropriate documentation E) editing E-R diagrams
Answer: E
Question 2: The simplest and most feasible means of recovering a database is through reprocessing.
Answer: False
Question 3: In comparison to reprocessing, rollforward does not involve the application programs
Answer: True
Question 4: Which of the following is not true of database recovery through reprocessing? A)
Reprocessing makes use of a database save. B) Reprocessing takes the same amount of time as did
processing in the first place. C) Reprocessing will always return the database to its exact previous
state. D) Reprocessing requires a record of all transactions since the last time the database was saved.
E) Processing cannot be resumed at a precise point.
Answer: C
Question 5: A point of synchronization between the database and the transaction log is called a(n)
________. A) before-image B) after-image C) recovery D) checkpoint E) None of the above
Answer: D
Question 6: Computer systems fail for which of the following reasons except? A) Hardware breaks.
B) Electrical power fails. C) Programs have bugs. D) Databases randomly changed field values. E)
People make mistakes
Answer: D
Question 7: Database administrators must make sure that ________ and ________ techniques and
procedures are operating to protect the database in case of failure and to recover it as quickly and
accurately as possible when necessary.
Answer: backup; recovery
Question 8: Transaction results are kept in a(n) ____ , which contains records of the data changes in
chronological order
Page 1
, Answer: log
Question 9: The recovery method where the database is restored using the saved data, and all
transactions since the save are reapplied is called ____ recovery.
Answer: rollfoward
Question 10: The recovery method in which we undo the changes that erroneous or partially
processed transactions have made in the database is called _ ___ recovery.
Answer: rollback
Question 11: An ACID transaction is one that is all but ____ _. A) atomic B) consistent C) isolated D)
durable E) guaranteed
Answer: E
Question 12: Ensuring that each SQL statement independently processes consistent rows is known as
___ _. A) transaction level consistency B) independent consistency C) statement level consistency D)
process level consistency E) serializable consistency
Answer: C
Question 13: All actions in an atomic transaction are completed successfully or none of the actions
are completed at all.
Answer: True
Question 14: A transaction in which all steps must be completed successfully or none of them will be
completed is called a durable transaction.
Answer: False
Question 15: Concurrent processing of a database only poses problems when two or more processes
attempt to use the same data.
Answer: True
Question 16: A dirty read is a problem with concurrent processing when a transaction rereads data it
has already read and finds modifications or deletions caused by another transaction.
Answer: False
Page 2
Question 1: Additional DBA responsibilities do not include ___ _. A) problem and error reporting B)
requests of changes to existing systems C) controlling database configuration D) maintaining
appropriate documentation E) editing E-R diagrams
Answer: E
Question 2: The simplest and most feasible means of recovering a database is through reprocessing.
Answer: False
Question 3: In comparison to reprocessing, rollforward does not involve the application programs
Answer: True
Question 4: Which of the following is not true of database recovery through reprocessing? A)
Reprocessing makes use of a database save. B) Reprocessing takes the same amount of time as did
processing in the first place. C) Reprocessing will always return the database to its exact previous
state. D) Reprocessing requires a record of all transactions since the last time the database was saved.
E) Processing cannot be resumed at a precise point.
Answer: C
Question 5: A point of synchronization between the database and the transaction log is called a(n)
________. A) before-image B) after-image C) recovery D) checkpoint E) None of the above
Answer: D
Question 6: Computer systems fail for which of the following reasons except? A) Hardware breaks.
B) Electrical power fails. C) Programs have bugs. D) Databases randomly changed field values. E)
People make mistakes
Answer: D
Question 7: Database administrators must make sure that ________ and ________ techniques and
procedures are operating to protect the database in case of failure and to recover it as quickly and
accurately as possible when necessary.
Answer: backup; recovery
Question 8: Transaction results are kept in a(n) ____ , which contains records of the data changes in
chronological order
Page 1
, Answer: log
Question 9: The recovery method where the database is restored using the saved data, and all
transactions since the save are reapplied is called ____ recovery.
Answer: rollfoward
Question 10: The recovery method in which we undo the changes that erroneous or partially
processed transactions have made in the database is called _ ___ recovery.
Answer: rollback
Question 11: An ACID transaction is one that is all but ____ _. A) atomic B) consistent C) isolated D)
durable E) guaranteed
Answer: E
Question 12: Ensuring that each SQL statement independently processes consistent rows is known as
___ _. A) transaction level consistency B) independent consistency C) statement level consistency D)
process level consistency E) serializable consistency
Answer: C
Question 13: All actions in an atomic transaction are completed successfully or none of the actions
are completed at all.
Answer: True
Question 14: A transaction in which all steps must be completed successfully or none of them will be
completed is called a durable transaction.
Answer: False
Question 15: Concurrent processing of a database only poses problems when two or more processes
attempt to use the same data.
Answer: True
Question 16: A dirty read is a problem with concurrent processing when a transaction rereads data it
has already read and finds modifications or deletions caused by another transaction.
Answer: False
Page 2
