New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Full Access Oracle 1z0-084 Tutorials

Previous
Page: 3 / 3
Question 12

18. The application provider has given full indications regarding the procedure to collect statistics.

To reduce the space used in the SYSAUX tablespace, you want to prevent the optimizer statistics Advisor from running.

Which method will allow you to do this?

Options:

A.

Set the parameter OPTIMIZER_ADAPTIVE_STATISTICS to FALSE.

B.

Use DBMS_AUTO_TASK_ADMIN. DISABLE to disable the AUTO_STATS_ADVISOR_TASK task.

C.

Set the AUTO_STATS_ADVISOR_TASK global statistics preference to FALSE.

D.

Use DBMS STATS.DROP ADVISOR TASK to drop the AUTO_STATS_ADVISOR_TASK task.

Question 13

Examine these statements and output:

What parameter change activates the generation and use of SQL Plan Directives7

Options:

A.

optimizer_features_enable=12.2.0.1

B.

optimizer_capture_sql_plan_baselines_TRUE

C.

optimizer_dynamic_sampling=11

D.

optimizer_adaptive_plans=TRUE

E.

optimizer_adaptive_statistics = TRUE

Question 14

During which application lifecycle phase do you take baselines?

Options:

A.

Testing

B.

Migration or upgrade

C.

Design and development

D.

Deployment

E.

Production

Question 15

Which two statements are true about cursor sharing?

Options:

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.

Previous
Page: 3 / 3
New Release 1z0-084 Oracle Certification Questions, Full Access Oracle 1z0-084 Tutorials,
Exam Code: 1z0-084
Exam Name: Oracle Database 19c: Performance Management and Tuning
Last Update: Dec 23, 2024
Questions: 55
1z0-084 pdf

1z0-084 PDF

$25.5  $84.99
 Add to Cart
1z0-084 Engine

1z0-084 Testing Engine

$28.5  $94.99
 Add to Cart
1z0-084 PDF + Engine

1z0-084 PDF + Testing Engine

$40.5  $134.99
 Add to Cart