Introduction to Oracle 9i SQL: 1Z0-007 Exam
1Z0-007 Questions & Answers
Exam Code: 1Z0-007
Exam Name: Introduction to Oracle 9i SQL
Q & A: 168 Q&As
Part: A 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’, ‘ ‘); Correct Answers: C E F Read More