Question

In the below query, which of the following insert statements will throw an error? CREATE TABLE employees (id INT, name VARCHAR (20), salary NOT NULL); INSERT INTO employee VALUES (100,A,O); INSERT INTO employee VALUES (101,B,); INSERT INTO employee VALUES (103,C,335);​

Answer 1

Answer:

INSERT INTO employee(101,B) will throw an error since you have put NOT NULL constraint on salary and not given a value for the same