Which three statements insert a row into the table? - ProProfs Discuss
Topics
Products
Follow Us:

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 ,\);
This question is part of Oracle Test2
Asked by Sudha_test, Last updated: Mar 31, 2020

+ Answer
Request

2 Answers

T. Moore

Have keen interest in writing, traveller by heart.

T. Moore, Writer, MA, Washington

Answered Jan 17, 2019

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.

 

John Smith

John Smith

Answered Jun 17, 2017

INSERT INTO employees VALUES ( 1000 , JOHN , NULL );
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, john ,");
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.