1z0-084 Practice Questions

A.  

Create the KEEP cache and cache tables accessed by the SQL statements.

B.  

Create the RECYCLE cache and cache tables accessed by the SQL statements.

C.  

Increase the size of the library cache.

D.  

Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINESto TRU

E.  

E.  

Set the CURSOR_SHARING parameter to FORC

E.  

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.

A.  

Set DB_FLASH_CACHE_SIZE to 192G and MEMORY_TARGET to 256

G.  

B.  

Set DB_FLASH_CACHE_SIZE parameter to 192

G.  

C.  

Disable Automatic Memory Management and set SGA_TARGET to 256

G.  

D.  

Set DB_FLASH_CACHE_SIZE to 256G and change device /dev/sdk to 128

G.  

E.  

Set DB_FLASH_CACHE_SIZE parameter to 128G, 64

G.  

A.  

By viewing V$SERV_MOD_ACT_STATS

B.  

In $ORACLE_BASE/diag/rdbms///trace

C.  

By viewing V$SERVICE_STATS

D.  

In the current working directory

A.  

Export the data by using expdp from Statspack and import it by using $ORACLE_HOME/rdbms/admin/awrload into the AWRrepository.

B.  

Export the data by using expdp from the ftatspack repository and import it by using impdp into the AWR repository.

C.  

Export the data by using the expdp utility and parameter file spuexp.par from the Statspack repository and import it by using impdp into Export the data by using expdp from

the Statspack repository and import it by using impdp into the AWR repository.

D.  

Export the data by using the exp utility and parameter file spuexp.par from the Statspack repository and import it by using imp into a dedicated Statspack schema on the destination.

A.  

With a target of 700 MB or more, all multipass executions work areas would be eliminated.

B.  

PGAA_AGGREGATE should be set to at least 800 M

B.  

C.  

GGREGATE_TARGET should be set to at least 700 M

B.  

D.  

With a target of 800 MB or more, all one-pass execution work areas would be eliminated.

A.  

Testing

B.  

Migration or upgrade

C.  

Design and development

D.  

Deployment

E.  

Production

A.  

SQL Performance Analyzer

B.  

AWR Compare Periods report

C.  

SQL Tuning Advisor

D.  

Active Session History report

A.  

Design and development

B.  

Upgrade or migration

C.  

Testing

D.  

Production

E.  

Deployment

A.  

Rows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.

B.  

Rows for sessions that are currently waiting have a wait time of 0.

C.  

Rows for sessions that are not waiting might contain the actual wait time for the last event for which they waited.

D.  

Rows for sessions that are currently waiting have their wait time incremented every microsecond.

E.  

Rows for sessions that are not waiting always contain the total wait time since the session started.