Consider the relation shown in the exhibit.
Which of the following SQL statements would properly add information for a new employee?
A.
INSERT INTO Employee
VALUES(0005, Tim, Bogart, 03-15-77);
B.
INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0004, Tim, Bogart, 03-15-77);
C.
INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);
D.
INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);
Are you sure #94 is “D”, i think it might be “A”. Great site, love it!, sorry if im wrong, im not very strong with SQL.
It’s D because first your identifying the columns in the table that you want to add data to, then the specific data that will occupy each intersection of the table.
Wrote my CIW Database Design Specialist 1D0-541 exam few days ago and passed with 92%! About 5 new questions, but not difficult at all. Total 50 questions, many questions on Normalization and Database Design/Structured Query Language (SQL), and DBMS/DDL/DML/DCL are still the most important objectives of the exam. BTW, the passing score now is 75%, and I learned all questions from passleader 1D0-541 dumps (http://www.passleader.com/1d0-541.html)
I do not see any difference between C and D, Sorry !