Multiple Choice
Suppose tables EMPLOYEE and CUSTOMER both store address information,and you want to send a letter to all employees and customers of your company to make a major announcement.Which SQL keyword would you most likely use here?
A) INTERSECT
B) UNION
C) UNION ALL
D) JOIN
Correct Answer:

Verified
Correct Answer:
Verified
Q32: The built-in function SUM can be used
Q33: Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL
Q34: The SQL built-in function ADDUP totals values
Q35: To remove duplicate rows from the result
Q36: The names of tables to be joined
Q38: SQL includes a data definition language,a data
Q39: SQL stands for Standard Query Language.
Q40: Only two tables can be queried by
Q41: The Microsoft Access wildcard character "_" (underscore)indicates
Q42: To obtain all columns,use an asterisk (*)wildcard