OMIS 452 Chapter 6 Questions and Answers
Save
3
Terms in this set (67)
Additional DBA responsibilities E
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
The simplest and most feasible False
means of recovering a database
is through reprocessing.
In comparison to reprocessing, True
rollforward does not involve the
application programs
,Which of the following is not C
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.
A point of synchronization D
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
, Computer systems fail for which D
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
Database administrators must backup; recovery
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.
Transaction results are kept in log
a(n) ________, which contains
records of the data changes in
chronological order
The recovery method where the rollfoward
database is restored using the
saved data, and all transactions
since the save are reapplied is
called ________ recovery.
Save
3
Terms in this set (67)
Additional DBA responsibilities E
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
The simplest and most feasible False
means of recovering a database
is through reprocessing.
In comparison to reprocessing, True
rollforward does not involve the
application programs
,Which of the following is not C
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.
A point of synchronization D
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
, Computer systems fail for which D
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
Database administrators must backup; recovery
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.
Transaction results are kept in log
a(n) ________, which contains
records of the data changes in
chronological order
The recovery method where the rollfoward
database is restored using the
saved data, and all transactions
since the save are reapplied is
called ________ recovery.
