Prev Question
Next Question

View the Exhibit and examine the structure of the CUST table.

Evaluate the following SQL statements executed in the given order:

ALTER TABLE cust
ADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_id) DEFERRABLE INITIALLY DEFERRED; INSERT
INTO cust VALUES (1,’RAJ’); –row 1
INSERT INTO cust VALUES (1,’SAM’); –row 2
COMMIT;
SET CONSTRAINT cust_id_pk IMMEDIATE;
INSERT INTO cust VALUES (1,’LATA’); –row 3
INSERT INTO cust VALUES (2,’KING’); –row 4
COMMIT;

Which rows would be made permanent in the CUST table?

A.
row 4 only

B.
rows 2 and 4

C.
rows 3 and 4

D.
rows 1 and 4

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *