Author Question: Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables. If you want to find all ... (Read 120 times)

HudsonKB16 · **on:** Jul 7, 2018

Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables. If you want to find all employees who are also customers, which SQL keyword would you most likely use?

A) INTERSECT
B) UNION
C) EXCEPT
D) UNION ALL

Question 2

The CAP Theorem defines three properties of distributed database systems, which are:

A) consistency, always-on, properties.
B) competency, always-on, properties.
C) consistency, availability, partition tolerance.
D) competency, availability, partition tolerance.
E) consistency, availability, properties.