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

Which three statements inserts 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: Jan 20, 2020

+ Answer
Request

1 Answer

sudha_test

Sudha_test

Answered Aug 07, 2018

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.