List of questions
Related questions
Question 55 - TDA-C01 discussion
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
* Every record must have a full name.
Which type of join should you use?
A.
Inner
B.
Left
C.
Full outer
D.
Union
Your answer:
0 comments
Sorted by
Leave a comment first