Which statement is true about redo log files during instance recovery?

• A.All current, online, and archived redo logs are required to complete instance recovery.
• B.All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.
• C.All redo log entries in the current log are applied to data files until the checkpoint position is reached.
• D.All current, active, and inactive redo logs are required to complete instance recovery.

Comment: *

Name: *

Email: *

Verification: *

After implementing full Oracle Data Redaction, you change the default value for the
NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?

• A.Re-enable redaction policies that use FULL data redaction.
• B.Re-create redaction policies that use FULL data redaction.
• C.Re-connect the sessions that access objects with redaction policies defined on them.
• D.Flush the shared pool.
• E.Restart the database instance.

Comment: *

Name: *

Email: *

Verification: *

The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
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.
References:

Comment: *

Name: *

Email: *

Verification: *

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

• A.Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• B.The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• C.The command will, create a common user whose description is contained in the root and each PDB.
• D.The schema for the common user C # # A_ADMIN can be different in each container.
• E.The command will create a user in the root container only because the container clause is not used.

Comment: *

Name: *

Email: *

Verification: *

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the
Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

• A.When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are
  automatically started.
• B.When a database instance is started by using the SRVCTL utility and listener startup fails, the instance
  is still started.
• C.When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart
  configuration.
• D.When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is
  automatically added to the Oracle Restart configuration.

Comment: *

Name: *

Email: *

Verification: *