You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1.Place all the user-defined tablespace in read-only mode on the source database.
2.Upgrade the source database to a 12c version.
3.Create a new PDB in the target container database.
4.Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5.Copy the associated data files and export the dump file to the desired location in the target database.
6.Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7.Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB
function.
Identify the correct order of the required steps.

• A.2, 1, 3, 4, 5, 6
• B.1, 3, 4, 5, 6, 7
• C.1, 4, 3, 5, 6, 7
• D.2, 1, 3, 4, 5, 6, 7
• E.1, 5, 6, 4, 3, 2

Comment: *

Name: *

Email: *

Verification: *

You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)

• A.The database must have multiplexed redo logs for the flashback to succeed.
• B.The database must be MOUNTED for the flashback to succeed.
• C.The database must use block change tracking for the flashback to succeed.
• D.The database must be opened in restricted mode for the flashback to succeed.
• E.The database must be opened with the RESETLOGS option after the flashback is complete.
• F.The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Comment: *

Name: *

Email: *

Verification: *

You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.
For which three reasons would you use the Compare Period ADDM report after the replay? (Choose three.)

• A.to compare the performance change of top SQL statements for the two runs
• B.to check the database time consumed for the two time periods
• C.to review the change in the initialization parameters between the two runs
• D.to review the hardware resources used during the two runs
• E.to check the performance improvement and degradation caused during the change
• F.to find the resource consumption by SQL statements that are common to both periods

Comment: *

Name: *

Email: *

Verification: *

Examine the details of the Top 5 Timed Eventsin the followingAutomaticWorkloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

• A.Cursors are not being shared.
• B.The buffers are being read into the buffer cache, but some other session is changing the buffers.
• C.The size of the shared pool is too small.
• D.There are frequent logons and logoffs.
• E.A large number COMMITS are being performed.

Comment: *

Name: *

Email: *

Verification: *

In which two scenarios is an RMAN recovery catalog automatically resynchronized?

• A.when a redo log Is archived
• B.when a registered database is opened with the resetlogs option
• C.when backup metadata records are aged out of the control file based on the control_file_record_keep_time parameter value
• D.when the backup retention policy configuration is changed for a registered database
• E.when a manual redo log switch is performed

Comment: *

Name: *

Email: *

Verification: *