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

The correct answer is C. INSERT INTO employees E. INSERT INTO employees (employee_id) F. INSERT INTO employees (employee_id, first_name, last_name). Since EMPLOYEE_ID column is used as primary key, it cannot be NULL, so only INSERT statements in C, E and F are correct. You can insert the row with NULL LAST_NAME as in answer C, or only the row with EMPLOYEE_ID as in answer E, or the row with empty LAST_NAME column. Incorrect…

Manipulating Data (DML)

Question

Examine the structure of the EMPLOYEES table:

EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? (Choose three)

Options

AINSERT INTO employees
BINSERT INTO employees( first_name, last_name)
CINSERT INTO employees
DINSERT INTO employees(first_name,last_name, employee_id)
EINSERT INTO employees (employee_id)
FINSERT INTO employees (employee_id, first_name, last_name)

How the community answered

(18 responses)

A
17% (3)
B
6% (1)
C
72% (13)
D
6% (1)

Explanation

Since EMPLOYEE_ID column is used as primary key, it cannot be NULL, so only INSERT statements in C, E and F are correct. You can insert the row with NULL LAST_NAME as in answer C, or only the row with EMPLOYEE_ID as in answer E, or the row with empty LAST_NAME column. Incorrect Answers A: This answer is incorrect because a primary key cannot be NULL. B: INSERT statement does not contain primary key value at all, so this answer needs to be eliminated as correct one. D: This statement shows incorrect order of columns of row which needs to be inserted into the

Topics

#INSERT statement#column list syntax#primary key NOT NULL#DML syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice