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 50 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
Gracias!

adf223

  • Member
  • Posts: 304
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

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.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Did you know?

Most childhood vaccines are 90–99% effective in preventing disease. Side effects are rarely serious.

Pyruvate oxidation results in three changes to pyruvate: Pyruvate oxidation results in three changes to pyruvate:
The traits Mendel used in his experiments, and the results of the F1 and F2 generation crosses. The traits Mendel used in his experiments, and the results of the F1 and F2 generation crosses.
Lab results Lab results
Distribution of skin color as measured by a reflectometer at a wavelength of 685 nm. The results are Distribution of skin color as measured by a reflectometer at a wavelength of 685 nm. The results are
Results of one round of replication of DNA Results of one round of replication of DNA
Predictions for the results of mutation of an overlapping and a nonoverlapping genetic code Predictions for the results of mutation of an overlapping and a nonoverlapping genetic code
Video: Types of Transport - Uniport, Antiport and Symport (Glucose and Na+K+ Transporters)

For a complete list of videos, visit our video library