Question 1

Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

Options :

A : They are never considered obsolete by RMAN.

B : They can optionally be written to a fast recovery area (FRA).

C : Â All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D : Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E : The SPFILE is included in the archival backup.

F : Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

G :

Answer: A,B,D

Question 2

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

Options :

A : to allow database duplication without a connection to the target instance

B : to store backup metadata that would cause the controlfile to become too large.

C : to store backups that would cause the controlfile to become too large

D : to report on the database schema at an earlier point in time.

E : to allow database duplication without a connection to the auxiliary instance.

Answer: A,B,D

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

choose two Which two are true about RMAN image copies?

Options :

A : They can only be written to disk.

B : They can be encrypted using Transparent Data Encryption (TDE).

C : They can be used as a level 0 incremental backup.

D : They can be used as a level 1 incremental backup.

E : They are the only backup option available for databases in NOARCHIVELOG mode.

Answer: A,C

Question 5

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

Options :

A : Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

B : A connection to an auxiliary instance is always required.

C : A subset of the target database can be duplicated.

D : A new DBID is always created for the duplicated database.

E : A connection to the recovery catalog instance is always required.

F : A backup of the target database is always required.

G : Duplication can be done by having the target database instance push copies to the auxiliary database instance.

H : A connection to the target database instance is always required.

Answer: A,B,C

Higher Test Marks with Free Online 1Z0-083 Exam Practice

Buying Options: