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 82 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
:D TYSM

sultansheikh

  • Member
  • Posts: 335
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Crossing Over Results in Genetic Recombination Crossing Over Results in Genetic Recombination
Benign prostatic hyperplasia. The condition results when an inner capsule of nonfunctional prostate Benign prostatic hyperplasia. The condition results when an inner capsule of nonfunctional prostate
Flow scattergrams showing results on the top set from a healthy donor and on the bottom set from a ... Flow scattergrams showing results on the top set from a healthy donor and on the bottom set from a ...
How does PCA reduce the dimension of a statistical problem? How do you select the reduced ... How does PCA reduce the dimension of a statistical problem? How do you select the reduced ...
An electropherogram showing the results of a DNA profile analysis An electropherogram showing the results of a DNA profile analysis
Results and interpretation of a mixed copolymer Results and interpretation of a mixed copolymer
Video: Type of Cell Junctions - Desmosome, Hemidesmosomes and Gap Junctions

For a complete list of videos, visit our video library