READ Free Dumps For Oracle- 1z0-062
| Question ID 2439 | What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled? |
| Option A | A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message |
| Option B | B. The rows in the table are truncated without being archived. |
| Option C | C. The rows in the table are archived, and then truncated. |
| Option D | D. The rows in both the table and the archive are truncated. |
| Correct Answer | B |
| Question ID 2440 | Which three activities are supported by the Data Recovery Advisor? |
| Option A | A. Advising on block checksum failures |
| Option B | B. Advising on inaccessible control files |
| Option C | C. Advising on inaccessible block change tracking files |
| Option D | D. Advising on empty password files |
| Option E | E. Advising on invalid block header field values |
| Correct Answer | A,B,E |