Which three statements insert a row into the table?
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25)
A. INSERT INTO employees VALUES (NULL, JOHN , Smith ); B. INSERT INTO employees( first_name, last_name) VALUES ( JOHN , Smith ); C. INSERT INTO employees VALUES ( 1000 , JOHN , NULL ); D. INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, john , Smith ); E. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, john ,\);
Based on the given structure, I know of two statements that will have the ability to insert a row into the table. The first one is letter A. The other statement that will have the ability to insert a row into the table is letter D. Inserting a row into the table can be important especially if you would like to keep your list of employees in alphabetical order.
You want to make sure that if ever you need to find data about the employees, you simply need to input the surname and find the employee that you are looking for. There may also be different categorizations that you may use so you can find the employees you need easily.
For example, you may come up with a category wherein the people from one department will be lumped together depending on the specification that you will choose. The year employed is also another category you may consider doing.