최신Oracle Database 19c Performance and Tuning Management - 1Z0-084무료샘플문제

A. optimizer_capture_sql_plan_baselines_TRUE

B. optimizer_dynamic_sampling=11

C. optimizer_features_enable=12.2.0.1

D. optimizer_adaptive_statistics = TRUE

E. optimizer_adaptive_plans=TRUE

A. Create an index on the CITY IP column.

B. Activate the adaptive plans.

C. Use a SQL Profile to enforce the appropriate plan.

D. Generate frequency histograms on the CITY__ID column.

E. Force the subquery to use dynamic sampling.

A. Setting optimizer_capture_sql_plan_baselines to TRUE loads all adaptive plans for the same statement into the cursor cache.

B. 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.

C. 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.

D. Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.

E. Adaptive Cursor Sharing guarantees that a suboptimal plan will never be used on any execution of a SQL statement.

A. Create an index on SALES.CUST_ID to force an INDEX RANGE SCAN on this index followed by a NESTED LOOP join between CUSTOMERS and SALES.

B. Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.

C. Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.

D. Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.

E. Enable Adaptive Plans so that Oracle can change the Join method as well as the Join order for this query.

A. Both SGA_TARGET and SGA_MAX_SIZE must be set to zero.

B. All auto-tuned SGA components are reset to their original user-defined values.

C. All SGA components retain their current sizes at the time of disabling.

D. The SGA size remains unaffected after disabling ASMM.

E. It requires a database instance restart to take effect.

F. All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM.

A. SQL Plan Directives

B. Dynamic Statistics

C. Automatic Reoptimization

D. Statistics Collector

E. Statistics Feedback