You Executed The Following Sql Statements In The Given Orderp #113

You executed the following SQL statements in the given order:</p> <pre><code class="language-sql"> CREATE TABLE orders (order_id NUMBER(3) PRIMARY KEY, order_date DATE, customer_idnumber(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; </code></pre> <p>The DELETE statement results in the following error:<br /> ERROR at line 1: table or view does not exist<br /> What would be the outcome?

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Concurrency Control - Insertion Deletion Predicate Reads - Quiz No.1.

 CREATE TABLE orders (order_id NUMBER(3) PRIMARY KEY, order_date DATE, customer_idnumber(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;