Skip to content

Tag: Free 1Z0-007

Oracle 1Z0-007 Exam Questions & Practice Test – Free Download

Posted in Oracle

Vendor: Oracle
Exam Code: 1Z0-007
Exam Name: Introduction to Oracle 9i SQL

QUESTION 1
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 ( 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)
VALUES (1000);
F.    INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’, ‘ ‘);

Answer: CEF