Multiple Choice
When incorrect data have been introduced, the database is best recovered by:
A) starting with a new ERD.
B) formatting server.
C) restarting from the most recent checkpoint and processing subsequent transactions.
D) reloading RDMS software.
Correct Answer:
Verified
Correct Answer:
Verified
Q96: Reduced uptime is a disadvantage of partitioning.
Q97: Backward recovery starts with an earlier copy
Q98: Hash partitioning spreads data evenly across partitions
Q99: A trigger can be used as a
Q100: Examination and modification of the SQL code
Q102: A DBMS periodically suspends all processing and
Q103: A join index is a combination of
Q104: A trigger can be used for security
Q105: Horizontal partitioning makes sense:<br>A) when different categories
Q106: All of the following are common denormalization