Suppose your company stores EMPLOYEE and CUSTOMER data in ...

[HudsonKB16]

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.

[T4T]

Answer to Question 1

A

Answer to Question 2

C

[HudsonKB16]

TYSM

[peter]

Thanks for the timely response, appreciate it