You execute the following piece of code with appropriate privileges:

User SCOTThas been granted the CREATE SESSIONprivilege and the MGRrole.
Which two statements are true when a session logged in as SCOTTqueries the SALcolumn in the view and the table?

• A.Data is redacted for the EMP.SALcolumn only if the SCOTTsession does not have the MGRrole set.
• B.Data is redacted for EMP.SALcolumn only if the SCOTTsession has the MGRrole set.
• C.Data is never redacted for the EMP_V.SALcolumn.
• D.Data is redacted for the EMP_V.SALcolumn only if the SCOTTsession has the MGRrole set.
• E.Data is redacted for the EMP_V.SALcolumn only if the SCOTTsession does not have the MGRrole set.

Comment: *

Name: *

Email: *

Verification: *

You are about to plug a multi-terabytenon-CDB into anexistingmultitenantcontainer database (CDB)as a pluggable database (PDB).
The characteristicsof the non-CDB are as follows:
----
Version:Oracle Database 12c Releases 1 64-bit Character set: WE8ISO8859P15 National character set: AL16UTF16 O/S: Oracle Linux6 64-bit
The characteristics of theCDBare as follows:
---
Version: Oracle Database 12c Release 1 64-bit Character set: AL32UTF8 O/S:OracleLinux 6 64-bit
Which technique should you use tominimize down time while pluggingthis non-CDB into the CDB?

• A.Transportable database
• B.Transportable tablespace
• C.Data Pump full export / import
• D.The DBMS_PDB package
• E.RMAN

Comment: *

Name: *

Email: *

Verification: *

The following parameter are set for your Oracle 12c database instance:

You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK
function.
3. Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK
function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK
function.
Identify the correct sequence of steps:

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

Correct Answer: B

*Evolving SQL Plan Baselines

2.Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description.
1.Set the evolve task parameters.
SET_EVOLVE_TASK_PARAMETER
This function updates the value of an evolve task parameter. In this release, the only valid parameter is TIME_LIMIT.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function.
3:IMPLEMENT_EVOLVE_TASK
This function implements all recommendations for an evolve task. Essentially, this function is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input parameters include task name, plan name, owner name, and execution name. 5.Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function. This function displays the results of an evolve task as a CLOB. Input parameters include the task name and section of the report to include.

Comment: *

Name: *

Email: *

Verification: *

You are about to pluga multi-terabytenon-CDB into an existingmultitenantcontainer database (CDB).
The characteristics of the non-CDB are as follows:
----
Version: Oracle Database 11gRelease 2 (11.2.0.2.0) 64-bit Character set: AL32UTF8 National character set: AL16UTF16 O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
----
Version: Oracle Database 12c Release 1 64-bit Character Set: AL32UTF8 National character set: AL16UTF16 O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

• A.Transportable database
• B.Transportable tablespace
• C.Data Pump full export/import
• D.The DBMS_PDB package
• E.RMAN

Comment: *

Name: *

Email: *

Verification: *

You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time?

• A.Increasing the priority of the job class to which the job belongs
• B.Increasing the job's relative priority within the Job class to which it belongs
• C.Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• D.Moving the job to an existing higher priority scheduler window with the same schedule and duration
• E.Increasing the value of the JOB_QUEUE_PROCESSESparameter
• F.Increasing the priority of the scheduler window to which the job belongs

Comment: *

Name: *

Email: *

Verification: *