Which three statements insert a row into the table?

Previous Question
Next Question

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( first_name, last_name)
VALUES( ‘John’, ‘Smith’);

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

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

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

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

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

Explanation:

: EMPLOYEE_ID is a primary key.
Incorrect answer :
A EMPLOYEE_ID cannot be null
B EMPLOYEE_ID cannot be null
Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-11

Previous Question
Next Question

Leave a Reply

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