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.
0
0
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.
0
0
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)
0
0
I do not see any difference between C and D, Sorry !
0
0