• Description:000-700 IBM DB2 UDB V8.1 Family Fundamentals
• Passing Score:75%
• Practice Test - Number of questions:99 questions
• Simulation Test - Number of questions:99 questions
• Simulation Test Duration:41 minutes
• Has explanations:No

Given the table definitions: DEFIN1: id SMALLINT NOT NULL name VARCHAR(30) hired DATE DEFIN2: deptid SMALLINT NOT NULL name VARCHAR(30) started DATE Assuming that neither table is empty, which of the following statements will insert data successfully into table DEFIN1?

Answer(s)

1. INSERT INTO defin1 (id) VALUES (1)
2. INSERT INTO defin1 (id, hired) AS SELECT DISTINCT 1, CURRENT DATE FROM defin2
3. INSERT INTO defin1 (name, hired) SELECT DISTINCT 'Florence', CURRENT DATE FROM defin2
4. INSERT INTO defin1 (name) VALUES ('Florence')

INSERT INTO defin1 (id) VALUES (1)