Oracle Exam 1Z0-064 Topic 1 Question 8 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 8
Topic #: 1

You are administrating a database that supports an OLTP workload. A new application module is deployed that is shipped along with the SQL plan baselines for the SQL statements executed by the application. You load the SQL plan baselines to the SQL Management Base.

Examine the parameters:

Which two statements are true in this scenario?

AThe SQL plan baselines are used but better execution plans may be found and can be evolved manually for the SQL statements.

BThe SQL plan baselines are used by the SQL statements and ensure that the best plan is used.

CThe SQL plan baselines are not used by the SQL statements if the optimizer statistics are stale.

DThe SQL plan baselines are loaded but are not used until SQL profiles are generated for the SQL statements.

Show Suggested Answer

Suggested Answer: C, D

by Daniel at May 07, 2022, 11:08 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!