📝 Question
#1681
You executed the following SQL statements in the given order: 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;
✓
Correct Answer
A. All the statements before the DELETE statement would be rolled back
💡
Explanation
Committing a transaction refers to making the changes to record in the database.
⌨️ Press
A
B
C
D
to select