A database administrator takes a full backup of the PRODUCTS database every Sunday. During the
week, two other backups are taken, one on Tuesday and one on Thursday. The PRODUCTS database
is about 800 GB in size, and about 20 percent of the data is modified throughout a week. Assuming
that backup times need to be kept to a minimum, which command should be used to produce the
Tuesday and Thursday backup images?

A database named PAYROLL was backed up on Sunday. On Tuesday, a table space in the PAYROLL
database was renamed from TBSP1 to EMPINFO_TBSP. On Thursday, the database was restored
from the backup image created on Sunday. Which command must be issued to roll the renamed
table space forward to the current date and time?

Due to an application error, some data was deleted from a very large table residing in table space
TS1. The table space was then renamed TS2 before the error was detected. Rather than try and
rebuild this table, it was decided that database DB1 would be restored and then rolled forward to a
point-in-time (PIT) before the delete operation took place. Unfortunately the PiT roll forward was
done to a time that was too early and some critical transactions were missing when the database
was brought back on-line. Which steps must be taken to ensure that the critical transactions which
are currently missing from the database are correctly applied to the database and that table space
TS1 is renamed TS2?

If a non-recoverable database crashes, how can a DBA successfully restart the database if a table
space is damaged and cannot complete crash recovery?

A database administrator created a new database from an existing full database backup image. If the
original database resided on a 64-bit AIX server and the new database was created on a different 64-
bit AIX server, which two statements are correct? (Choose two.)

Which statement is correct when describing the AUTOCONFIGURE command?