READ Free Dumps For Oracle- 1z0-007
Question ID 1700 | Evaluate the set of SQL statements: |
Option A | A. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist. |
Option B | B. The DESCRIBE DEPT statement displays the structure of the DEPT table. |
Option C | C. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement. |
Option D | D. The ROLLBACK statement frees the storage space occupied by the DEPT table. |
Correct Answer | B |
Question ID 1701 | Examine the structure of the EMPLOYEES table: |
Option A | A. Your last update fails to update any rows because employee ID 180 was already deleted. |
Option B | B. You have no rows in the table. |
Option C | C. You cannot roll back to the same savepoint more than once. |
Option D | D. You have an employee with the name of James. |
Correct Answer | B |