READ Free Dumps For Oracle- 1z0-060
| Question ID 2207 |
|
| Option A | A. SYS sessions, regardless of the roles that are set in the session |
| Option B | B. SYSTEM sessions, regardless of the roles that are set in the session |
| Option C | C. SCOTT sessions, only if the MGR role is set in the session |
| Option D | D. SCOTT sessions, only if the MGR role is granted to SCOTT |
| Option E | E. SCOTT sessions, because he is the owner of the table |
| Correct Answer | A,B,D |
| Question ID 2208 | 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 | C |