READ Free Dumps For Oracle- 1z0-062
| Question ID 2463 | Which three statements are true about SQL plan directives? |
| Option A | A. They are tied to a specific statement or SQL ID. |
| Option B | B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan. |
| Option C | C. They are used to gather only missing statistics. |
| Option D | D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect. |
| Option E | E. They instruct the optimizer to create only column group statistics. |
| Option F | F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace. |
| Correct Answer | B,D,E |
| Question ID 2464 | You want to flash back a test database by five hours. |
| Option A | A. The database must have multiplexed redo logs for the flashback to succeed. |
| Option B | B. The database must be MOUNTED for the flashback to succeed. |
| Option C | C. The database must use block change tracking for the flashback to succeed. |
| Option D | D. The database must be opened in restricted mode for the flashback to succeed. |
| Option E | E. The database must be opened with the RESETLOGS option after the flashback is complete. |
| Option F | F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN. |
| Correct Answer | B,E |