Which of the following queries will never be executed successfully due to primary key violation (Assume that ID field is a primary key and there exist records with ID=1 and ID=3)?

Question

Accepted Answer

INSERT INTO EMPLOOYEES (ID, FIRSTNAME, LASTNAME, SALARY) SELECT 3, FIRSTNAME, LASTNAME, SALARY FROM EMPLOOYEES WHERE ID = 1

Accepted Answer

INSERT INTO EMPLOOYEES (ID, FIRSTNAME, LASTNAME, SALARY)  VALUES (3, 'Ivan', 'Fedorenko', 2000)

Answer

INSERT INTO EMPLOOYEES (ID, FIRSTNAME, LASTNAME, SALARY)  VALUES (6, 'Ivan', 'Fedorenko', 2300)

Answer

INSERT INTO EMPLOOYEES (ID, FIRSTNAME, LASTNAME, SALARY) SELECT 4, FIRSTNAME, LASTNAME, SALARY FROM EMPLOOYEES WHERE ID IN (1, 3)

Answer

INSERT INTO EMPLOOYEES (ID, FIRSTNAME, LASTNAME, SALARY)  SELECT 5, FIRSTNAME, LASTNAME, SALARY  FROM EMPLOOYEES WHERE ID = 3

Crowdly

Which of the following queries will never be executed successfully due to primar...

Want instant access to all verified answers on softserve.academy?