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: *

Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

• A.LOG_BUFFER
• B.SORT_AREA_SIZE
• C.JAVA_POOL_SIZE
• D.STREAMS_POOL_SIZE
• E.DB_16K_CACHE_SZIE
• F.DB_KEEP_CACHE_SIZE

Correct Answer: A,E,F

Manually Sized SGA Components that Use SGA_TARGET Space SGA Component,Initialization Parameter
/The log buffer
LOG_BUFFER
/The keep and recycle buffer caches
DB_KEEP_CACHE_SIZE
DB_RECYCLE_CACHE_SIZE
/Nonstandard block size buffer caches
DB_nK_CACHE_SIZE
Note:
* In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed inthe table belowto enable full automatic tuning of the automatically sized SGA components.
* Table,Automatically Sized SGA Components and Corresponding Parameters

Comment: *

Name: *

Email: *

Verification: *

Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?

• A.alphanumeric columns that need conversion to a different binary representation before converging to the chosen Unicode character set
• B.alphanumeric columns that need no conversion
• C.numeric columns that will exceed the column size limit after converting to the chosen Unicode character set
• D.date columns that will have invalid binary representation after converting to the chosen Unicode character set
• E.alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode character set
• F.numeric columns that will have invalid binary representation after converting to the chosen Unicode character set

Comment: *

Name: *

Email: *

Verification: *

A new report process containing a complex query is written, with high impact on the database.
You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

• A.Execute the query and view Active Session History (ASH) for information about the query.
• B.Enable SQL trace for the query.
• C.Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_ MONITOR function to view the report.
• D.Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

Comment: *

Name: *

Email: *

Verification: *

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disruption to availability is required.
Which three statements are true about this requirement? (Choose three.)

• A.The partitions can be moved online to new tablespaces.
• B.Global indexes must be rebuilt manually after moving the partitions.
• C.The partitions can be compressed in the same tablespaces.
• D.The partitions can be compressed in the new tablespaces.
• E.Local indexes must be rebuilt manually after moving the partitions.

Comment: *

Name: *

Email: *

Verification: *