Free Oracle 1z1-084 Exam Dumps Questions & Answers

Examine this statement and output:

Which two situations can trigger this error?

• A.There is a file in the capture directory.
• B.The instance is unable to access the capture directory.
• C.The syntax is incomplete.
• D.The capture directory is part of the root file system.
• E.The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory.

Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?

• A.enq: TM - contention
• B.enq: SQ - contention
• C.enq: HW - contention
• D.enq: TX - allocate ITL entry

Which procedure gathers statistics that are always used in the generation of any execution plan?

• A.DBMS_STATS.GATHER_SYSTEM_STATS
• B.DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS
• C.DBMS_STATS.GATHER_DATABASE_STATS
• D.DBMS_STATS.GATHER_DICTIONARY_STATS

Which Optimizer component helps decide whether to use a nested loop join or a hash join in an adaptive execution plan?

• A.Automatic Reoptimization
• B.SQL Plan Directives
• C.Statistics Collector
• D.Dynamic Statistics
• E.Statistics Feedback

Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?

• A.A 60% cache hit ratio can be observed for database instances which have very good I/O performance.
• B.Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.
• C.The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.
• D.The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.
• E.A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.