This topic contains a solution. Click here to go to the answer
« previous next »

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

HudsonKB16

  • Hero Member
  • *****
  • Posts: 535
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.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

T4T

  • Sr. Member
  • ****
  • Posts: 348
Reply #1 on: Jul 7, 2018
Answer to Question 1

A

Answer to Question 2

C


HudsonKB16

  • Member
  • Posts: 535
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

Liddy

  • Member
  • Posts: 342
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

How to find the average atomic mass of an element How to find the average atomic mass of an element
How to use a tree diagram to find the probability How to use a tree diagram to find the probability
Find the voltage, current and power for each resistor in the circuit below Find the voltage, current and power for each resistor in the circuit below
Find the resultant for the following force combinations Find the resultant for the following force combinations
1) (a) What is Coulomb?s Law? (b) Find the net electrostatic force on the charge labeled ?P? in ... 1) (a) What is Coulomb?s Law? (b) Find the net electrostatic force on the charge labeled ?P? in ...
Type III curve. Mortality is highest early in life. Data for a desert shrub (Cleome droserifolia). Type III curve. Mortality is highest early in life. Data for a desert shrub (Cleome droserifolia).
Video: Protein Secondary and Tertiary Structures - Animation

For a complete list of videos, visit our video library