nerdexam
CIW

1D0-441 · Question #82

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

The correct answer is D. INSERT INTO Employee (Emp_ID, First_Name, Last_Name, Birth_Date) VALUES (0005, Tim. See the full explanation below for the reasoning.

Question

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

Exhibit

1D0-441 question #82 exhibit

Options

  • AINSERT INTO Employee
  • BINSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim,
  • CINSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim,
  • DINSERT INTO Employee (Emp_ID, First_Name, Last_Name, Birth_Date) VALUES (0005, Tim,

How the community answered

(52 responses)
  • A
    12% (6)
  • B
    2% (1)
  • C
    6% (3)
  • D
    81% (42)

Community Discussion

No community discussion yet for this question.

Full 1D0-441 Practice