Oracle
1Z0-117 · Question #50
1Z0-117 Question #50: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
Question
You are administering a database supporting an OLTP workload where the users perform frequent queries for fetching a new rows as possible, involving join operations on recently inserted data. In addition at night, a few DSS queries are also performed. Examine the initialization parameters for the instance: Which two options would you use for the optimizer?
Exhibit
Options
- ASet the OPTIMIZER_MODE initialization parameter to FIRST_ROWS_n.
- BAdd the hint ALL_ROWS in the DOS queries.
- CSet the OPTIMIZER_INDEX_CACHING initialization parameter to 0.
- DAdd a hint INDEX_COMBINE in all DSS queries.
- ESet the OPTIMIZER_INDEX_COST_ADJ initialization parameter to 100.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.