Oracle 1Z0-083 Value Pack (Frequently Bought Together)

Which three are true about Recovery Manager (RMAN) active database duplication?

• A. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.
• B. The active database must be duplicated while in OPEN state.
• C. Pre-existing backups of the database to be duplicated are always used if they exist.
• D. Backup sets can be used to duplicate the active database.
• E. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.
• F. Image copies can be used to duplicate the active database.
• G. No connection to the recovery catalog is required for active database duplication.

Which three statements are true about Flashback Data Archive?

• A. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
• B. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.
• C. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
• D. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database
• E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• B. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D. Settingthetargettablespacetoread-only
• E. Setting the target tablespace offline

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?

• 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 partial resync at the next backup.
• C. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.
• D. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

Which four are true about RMAN backup sets? (Choose four.)

• A. A backup piece can belong to only one backup set.
• B. A backup set can contain only one backup piece.
• C. A backup set must be written to media.
• D. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• E. A backup set must be written to disk.
• F. Blocks from multiple data files can be contained in one backup piece,
• G. Blocks from multiple data files can be contained in one backup set,
• H. A data file can be split into multiple sections stored in different backup sets.