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

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

Comment: *

Name: *

Email: *

Verification: *

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 dbid and set new name for tablespace to recover the database to the new host
• B.by using the RMAN switch command to set the new location for the data files
• C.by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
• D.by creating a new database in the new host, and then using the RMAN recover command

Comment: *

Name: *

Email: *

Verification: *

Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

• A.Run the Memory Advisor for the shared pool.
• B.Run the Memory Advisor for the Program Global Area.
• C.Run the Memory Advisor for the System Global Area.
• D.Run the SQL Tuning Advisor.
• E.Run the SQL Access Advisor.

Comment: *

Name: *

Email: *

Verification: *

Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?

• A.when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
• B.when a new tablespace is added to a registered target database
• C.when a backup of the current control file is created
• D.when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
• E.when the target is first registered

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle database methodology? (Choose two.)

• A.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• B.The database instance memory should always be tuned before tuning any file systems.
• C.SQL statements should always be tuned before tuning any file systems.
• D.Tuning activities should stop once agreed service levels for performance have been met.
• E.Tuning activities should stop once the user is satisfied with performance.
• F.The alert log should be used to find the database and instance areas most in need of tuning.

Comment: *

Name: *

Email: *

Verification: *