Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

• A.The optimizer used a dynamic plan for the query.
• B.The optimizer chose different plans because automatic dynamic sampling was enabled.
• C.The optimizer used re-optimization cardinality feedback for the query.
• D.The optimizer chose different plan because extended statistics were created for the columns used.

Comment: *

Name: *

Email: *

Verification: *

You execute the following PL/SQL: Which two statements are true?

• A.Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
• B.FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
• C.FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
• D.FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Comment: *

Name: *

Email: *

Verification: *

You upgrade your Oracle database in a multiprocessor environment. As a recommended
you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

• A.Parallel compilation of only the stored PL/SQL code
• B.Sequential recompilation of only the stored PL/SQL code
• C.Parallel recompilation of any stored PL/SQL code
• D.Sequential recompilation of any stored PL/SQL code
• E.Parallel recompilation of Java code
• F.Sequential recompilation of Java code

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

• A.The CDB must be open.
• B.The CDB must be in the mount stage.
• C.The CDB must be in the nomount stage.
• D.Alt existing PDBs must be closed.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding constraints?

• A.A constraint is enforced only for the insert operation on a table.
• B.A column with the unique constraint can contain null values.
• C.All constraints can be defined at the column level as well as the table level.
• D.A foreign key cannot contain null values.
• E.A constraint can be disabled even if the constraint column contains data.

Comment: *

Name: *

Email: *

Verification: *