OCP CBT Question 553

Please solve the following question.

Consider the `employees` table with `first_name` and `last_name` columns defined as `NOT NULL`. You attempt to execute the following statement: ```sql INSERT INTO employees (employee_id, first_name, email, hire_date, job_id, salary, department_id) VALUES (207, 'John', 'JOHN@EXAMPLE.COM', SYSDATE, 'IT_PROG', 6000, 60); ``` What is the most likely outcome?

The statement will succeed, and the last_name will be set to an empty string.

The statement will succeed, and the last_name will be set to NULL.

The statement will fail with an ORA-01400 error: 'cannot insert NULL into ([owner.]table.column)'.

The statement will fail because last_name is not included in the column list.