Which three statements insert a row into the table? - ProProfs Discuss
Advertisement

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)

This question is part of oracle test2
Asked by Sudha_test, Last updated: Oct 15, 2020

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

T. Moore

T. Moore

Have keen interest in writing, traveller by heart.

T. Moore
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.

upvote downvote
Reply 

John Smith

John Smith

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 ,");
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

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