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 /RAJ1); –row 1 INSERT INTO cust VALUES (1 ,’SAM); –row 2 COMMIT;
SET CONSTRAINT cust_id_pk IMMEDIATE; INSERT INTO cust VALUES (1 /LATA1);
–row 3 INSERT INTO cust VALUES (2 .KING1); –row 4 COMMIT; Which rows would be
made permanent in the CUST table?
A.
rows 1 and 4
B.
rows 3 and 4
C.
rows 2 and 4
D.
row 4 only