Free Oracle 1Z0-084 Exam Dumps Questions & Answers

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

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

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 cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.
• D.  Setting optimizer_capture_sql_plan_baselines to TRUE loads all adaptive plans for the same statement into the cursor cache.
• 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.

Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

• A.  Increase PCTFREE for the SALES table.
• B.  Compress the SALES table.
• C.  Re-create the SALES table.
• D.  Partition the SALES table.
• E.  Coalesce all sales table indexes.

A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

• A.  Increasing DB_CACHESIZE to 1 G
• B.  Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25
• C.  Setting PARALLEL_DEGREE_POLICYAUTO
• D.  Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50
• E.  Setting PARALLEL_DEGREE_POLICYADAPTIVE
• F.  Setting DB_KEEP_CACHE_SIZE to at least 50M

Which application lifecycle phase could be managed reactively?

• A.  Upgrade or migration
• B.  Production
• C.  Design and development
• D.  Testing
• E.  Deployment