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

Author Question: Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query? A) ... (Read 49 times)

captainjonesify

  • Hero Member
  • *****
  • Posts: 543
on: Jul 7, 2018
Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?
 
  A) UNIQUE
  B) SORT
  C) ORDER BY
  D) DISTINCT
  E) REDUCE

Question 2

________ constraints are rules that the DBMS enforces to ensure that data values in one table have corresponding values in another related table.
 
  Fill in the blank(s) with correct word


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

verrinzo

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

D

Answer to Question 2

Referential integrity


captainjonesify

  • Member
  • Posts: 543
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it

cam1229

  • Member
  • Posts: 329
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

(a) Feeding by bear on salmon results in large allochthonous inputs of nutrients into (b) the forest (a) Feeding by bear on salmon results in large allochthonous inputs of nutrients into (b) the forest
Crossing Over Results in Genetic Recombination Crossing Over Results in Genetic Recombination
Monitoring and Following Up on Laboratory Test Results Monitoring and Following Up on Laboratory Test Results
Blood types and results of donor and recipient combinations. Blood types and results of donor and recipient combinations.
The results of reciprocal crosses between streptomycin-resistant and streptomycin-sensitive The results of reciprocal crosses between streptomycin-resistant and streptomycin-sensitive
Results of mixing blood of the same or differing ABO blood types Results of mixing blood of the same or differing ABO blood types
Video: Acid-base imbalances - compensation of metabolic acidosis and alkalosis

For a complete list of videos, visit our video library