BOB and ALICE moved from the DEVELOPER group to the ANALYST group.
As the security administrator, which two commands would remove Bob and Alice from the
DEVELOPER group? (Choose two.)

Because of an application abend, a database named PAYROLL needs to be restored to approximately
9:26 am on June 1, 2009. After the database is restored from a backup image, the command shown
below is executed:
ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP
When this command is executed, the error shown below is generated:
SQL4970N Roll-forward recovery on database “PAYROLL” cannot reach the specified stop point (endof-log or point-in-time) because of missing log file(s) on node(s) “0”. Which two commands could be
used to resolve this error? (Choose two.)

Which two can be replicated using HADR? (Choose two.)

Which set of procedures will be required to perform a rolling upgrade in a HADR environment?

Which HADR feature minimizes the impact of software maintenance on the Standby server?

Refer to the Exhibit.

Refer to the logging configuration parameters shown in the exhibit.
What will happen if there are currently 100 active log files and DB2 needs to create log file 101?

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?