Oracle
1Z0-047 · Question #146
1Z0-047 Question #146: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #146. The question stem and answer options stay visible for context.
Question
You executed the following SQL statements in the given order: CREATE TABLE orders (order_id NUMBER(3) PRIMARY KEY, order_date DATE, customer_id number(3)); INSERT INTO orders VALUES (100,'10-mar-2007,,222); ALTER TABLE orders MODIFY order_date NOT NULL; UPDATE orders SET customer_id=333; DELETE FROM order; The DELETE statement results in the following error: ERROR at line 1: ORA-00942: table or view does not exist What would be the outcome?
Options
- AAll the statements before the DELETE statement would be rolled back.
- BAll the statements before the DELETE statement would be implicitly committed within the session.
- CAll the statements up to the ALTER TABLE statement would be committed and the outcome of
- DAll the statements up to the ALTER TABLE statement would be committed and the outcome of the
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.