Which two options are part of a Soft Parse operation?

• A.Semantic Check
• B.Syntax Check
• C.Shared Pool Memory Allocation
• D.SQL Row Source Generation
• E.SQL Optimization

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about cursor sharing?

• A.Setting Cursor_sharing to FORCE can result in a plan that is suboptimal for the majority of values bound to a bind variable when executing a cursor with one or more bind variables.
• B.Adaptive Cursor Sharing guarantees that a suboptimal plan will never be used on any execution of a SQL statement.
• C.Setting optimizer_capture_sql_plan_baselines to TRUE loads all adaptive plans for the same statement into the cursor cache.
• D.Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.
• E.Adaptive Cursor Sharing requires histograms on filtered columns, used in equality predicates, to allow different execution plans to be generated for statements whose bound values would normally generate different plans at hard parse time.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about server-generated alerts?

• A.They are notifications from the Oracle Database Server of an existing or impending problem.
• B.They provide notifications but never any suggestions for correcting the identified problems.
• C.They are logged in the alert log.
• D.They can be viewed only from the Cloud Control Database home page.
• E.Their threshold settings can be modified by using DBMS_SERVER_ALERT.
• F.They may contain suggestions for correcting the identified problems.

Comment: *

Name: *

Email: *

Verification: *

What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?

• A.STATISTICS_LEVEL=ALL and
  CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING
• B.STATISTICS_LEVEL=BASIC and CONTROL_MANAGEMENT_PACK ACCESS=DIAGOSTIC
• C.STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS-
  DIAGOSTIC*TUNING
• D.STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC

Comment: *

Name: *

Email: *

Verification: *

Examine this statement and output:

Which three statements are true?

• A.Both 9822 and 8779 sessions are waiting for operating system resources.
• B.Session 8779 may be waiting due to a network problem.
• C.Session 9857 waited 1354 seconds for another process, which was also waiting for a transaction to end.
• D.Session 9857 is not waiting.
• E.Session 8779 may be waiting for a user or application response.
• F.Session 9822 will always stop waiting if the session that owns the TX enqueue issues a COMMIT statement as session 9822 is the first session in the transaction queue.

Comment: *

Name: *

Email: *

Verification: *