Question

20 Choose valid DML,
A. INSERT INTO TABLE EMPLOYEE ("EMP_ID","NAME", "STATE", "ZIP") VALUES (124, Vinod','UP',201301);
B. DELETE FROM EMPLOYEE WHERE EMP_ID=124;
C. UPDATE EMPLOYEE SET NAME='Rahul' WHERE EMP_ID=124;
a . Only option A is valid others are invalid b.Both A and B are valid, but C is invalid
c. Only C is valid.
d.Both B and Care valid, but A is invalid​

Answer 1

Answer:

d) both B and C are valid, but A is invalid.