Oracle 1Z0-083 valid exam dumps : Oracle Database Administration II

In which two situations can you use Database Upgrade Assistant? (Choose two.)

• A. when the operating system (OS) needs to be changed as part of the upgrade
• B. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
• C. when a character set conversion is required during the upgrade
• D. when the target and source database are on the same platform
• E. when the hardware platform needs to be changed as part of the upgrade

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).

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

• A. A target database's persistent RMAN configuration settings are always stored in the target's control file
• B. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• C. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
• D. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
• E. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• F. The RMAN SHOW ALL command displays only settings with nondefault values.
• G. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

• A. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
• B. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
• C. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
• D. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
• E. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
• F. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).

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

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

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

• A. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
• B. by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host
• C. by creating a new database in the new host, and then using the RMAN recover command
• D. by using the RMAN switch command to set the new location for the data files