Oracle
1Z0-007 · Question #150
1Z0-007 Question #150: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #150. The question stem and answer options stay visible for context.
Question
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?
Options
- AThe DESCRIBE DEPT statement displays the structure of the DEPT table.
- BThe ROLLBACK statement frees the storage space occupies by the DEPT table.
- CThe DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
- DThe DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.