Question
ERROR at line 1: table or view does not exist
What would be the outcome?
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;a.
All the statements before the DELETE statement would be rolled back
b.
All the statements before the DELETE statement would be implicitly committed within the session
c.
All the statements up to the ALTER TABLE statement would be committed and the outcome of UPDATE statement would be rolled back
d.
All the statements up to the ALTER TABLE statement would be committed and the outcome of the UPDATE statement is retained uncommitted within the session
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. You executed the following SQL statements in the given order. The DELETE statement results in the following error: ERROR at line 1: table or view does not exist What would be...
Similar Questions
Discover Related MCQs
Q. Which statements are correct regarding indexes?
View solution
Q. Which of the following causes system to crash
View solution
Q. The database is partitioned into fixed-length storage units called
View solution
Q. The failure occurred sufficiently early during the transfer that the destination block remains intact.
View solution
Q. Which kind of failure loses its data in head crash or failure during transfer operation.
View solution
Q. The assumption that hardware errors and bugs in the software bring the system to a halt, but do not corrupt the nonvolatile storage contents, is known as the
View solution
Q. The transaction can no longer continue with its normal execution because of some internal condition, such as bad input, data not found, overflow, or resource limit exceeded. This is
View solution
Q. The system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is
View solution
Q. Which of the following belongs to transaction failure
View solution
Q. Which one of the following is a failure to system
View solution
Q. The recovery scheme must also provide
View solution
Q. Instead of locking index leaf nodes in a two-phase manner, some index concurrency-control schemes use ___________ on individual key values, allowing other key values to be inserted or deleted from the same leaf.
View solution
Q. B-link tree requires a pointer to its __________ sibling.
View solution
Q. In crabbing protocol to inset or delete a key value the leaf node has to be locked in ___________ mode.
View solution
Q. If needed to split a node or coalesce it with its siblings, or redistribute key values between siblings, the crabbing protocol locks the parent of the node in ____________ mode.
View solution
Q. In crabbing protocol the the lock obtained on the root node is in _________ mode.
View solution
Q. The deadlock can be handled by
View solution
Q. In crabbing protocol locking
View solution
Q. How many techniques are available to control concurrency on B+ trees?
View solution
Q. Why do we need concurrency control on B+ trees ?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
