CIW Exam 1D0-541 Topic 6 Question 48 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 48
Topic #: 6

Consider the relation shown in the exhibit. Which of the following SQL statements would

properly add information for a new employee?

AINSERT INTO Employee
VALUES(0005, Tim, Bogart, 03-15-77);

BINSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0004, Tim, Bogart, 03-15-77);

CINSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);

DINSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);

Show Suggested Answer

Suggested Answer: D

by Ligia at May 03, 2022, 01:19 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!