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) Which three statements
insert a row into the table? (Choose three.)

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements
insert a row into the table? (Choose three.)

A.
INSERT INTO employees VALUES ( 1000, ‘John’, NULL);

B.
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,
‘ ‘);

C.
INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, ‘John’,
‘Smith’)

D.
INSERT INTO employees( first_name, last_name) VALUES( ‘John’, ‘Smith’);

E.
INSERT INTO employees VALUES ( NULL, ‘John’, ‘Smith’);

F.
INSERT INTO employees (employee_id) VALUES (1000);



Leave a Reply 2

Your email address will not be published. Required fields are marked *


mario

mario

why d in incorrect?

saurabh

saurabh

in D option employee_id is not inserted which is primary key (Not Null, Unique).