READ Free Dumps For Oracle- 1z0-050
| Question ID 1772 | View the Exhibit exhibit1 to examine the series of SQL commands.
|
| Option A | A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
|
| Option B |
B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
|
| Option C | C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan. |
| Option D | D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation. |
| Correct Answer | B |
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.| Question ID 1773 | Which statement describes the effect of table redefinition on the triggers attached to the table? |
| Option A | A. All triggers on the table remain valid. |
| Option B | B. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table ' |
| Option C | C. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table. |
| Option D | D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table. |
| Correct Answer | B |