Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Assume all the following four statements are executed in the same sequence order.
S1: INSERT INTO employees (employee_id) VALUES (1000);
S2: INSERT INTO employees VALUES (‘1000’,‘John’,NULL);
S3: INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
S4: INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);
Which statement will not insert a row into the table?
→S2 won’t execute as we are trying to make primary key value as NuLL. But isn’t S4 also invalid?
