Question 1

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

Options :

A : The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B : RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C : The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D : The UNDO TABLESPACE clause is never required.

E : RMAN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

Answer: A,B

Question 2

choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

Options :

A : The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B : The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C : The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D : The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Answer: B

Question 3

Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?

Options :

A : A DBA must specify either a redundancy retention policy or a recovery window retention policy. B)A target database-s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

B : Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

C : Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.

D : A target database-s persistent RMAN configuration settings are always stored in the target-s control file

Answer: C,D

Question 4

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

Options :

A : By default, AWR snapshots are taken every 60 minutes.

B : Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

C : By default, AWR snapshots are retained for 7 days.

D : The taking of AWR snapshots can be disabled.

E : AWR data is stored in the SYSTEM tablespace.

Answer: A,B,D

Question 5

Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?

Options :

A : It uses multisection backup.

B : It uses parallelization for the backup set.

C : It uses asynchronousI/O for the backup.

D : It creates compressed backup sets.

Answer: B

Confidently Practice Online with Free 1Z0-083 Exam Cram

Buying Options: