READ Free Dumps For Oracle- 1z0-050
Question ID 1853 | Which three are the valid statements in relation to SQL plan baselines? (Choose three.) |
Option A | A. The plans can be manually loaded to the SQL plan baseline. |
Option B | B. The plans in the SQL plan baseline are verified and accepted plans. |
Option C | C. The plans generated for every SQL statement are stored in the SQL plan baseline by default. |
Option D | D. The plan baselines are stored temporarily in the memory as long as the database instance is running. |
Option E | E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online. |
Correct Answer | A,B,E |
Question ID 1854 | You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile? |
Option A | A. The tuned plan is not added to the SQL plan baseline. |
Option B | B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan. |
Option C | C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. |
Option D | D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan. |
Correct Answer | C |