Which three types of statistics are captured by statspack with snap level 6?

• A.Parent and child latches
• B.Parent and child latches
• C.Optimizer execution plans
• D.Plan usage data
• E.Enqueue statistics
• F.Segment-level statistics

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

You must configure and enable Database Smart Flash Cache for a database.
You configure these flash devices:

Examine these parameter settings:

What must be configured so that the database uses these devices for the Database Smart Flash Cache?

• A.Set DB_FLASH_CACHE_SIZE to 192G and MEMORY_TARGET to 256G.
• B.Set DB_FLASH_CACHE_SIZE parameter to 192G.
• C.Disable Automatic Memory Management and set SGA_TARGET to 256G.
• D.Set DB_FLASH_CACHE_SIZE to 256G and change device /dev/sdk to 128G.
• E.Set DB_FLASH_CACHE_SIZE parameter to 128G, 64G.

Comment: *

Name: *

Email: *

Verification: *

You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL PlanBaselinebut forget to disable the SQLProfile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true?

• A.The existence of two concurrent plan stability methods generates a child cursor for every execution.
• B.The SQL Profiles as well as SQL Plan Baseline are implemented using hints, so they both generate the same plan.
• C.The execution plan is the one enforced by the SQL Profile.
• D.The execution plan is the one enforced by the SQL Plan Baseline.
• E.The SQL Plan Baseline must be accepted in order to be used for the execution plan.
• F.The conflict between the two plan stability methods results in an error.

Comment: *

Name: *

Email: *

Verification: *

Which two actions can cause invalidation or loss of one or more results in the SQL Query Result Cache?

• A.One or more results were aged out of the result cache.
• B.result_cache_max_size is set dynamically to 0.
• C.A request was made by the RCBG background of a non-RAC database.
• D.A request was made by the RCBG background process in a physical standby database that is opened read only and whose primary has a result cache.
• E.Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.

Comment: *

Name: *

Email: *

Verification: *