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 72 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
YES! Correct, THANKS for helping me on my review

mammy1697

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

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?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

Results from sequential study of two cohorts tested at three ages and at three different points in t Results from sequential study of two cohorts tested at three ages and at three different points in t
Blood types and results of donor and recipient combinations. Blood types and results of donor and recipient combinations.
Select the proper adapter for the compression gauge. The threads on the adapter should match those ... Select the proper adapter for the compression gauge. The threads on the adapter should match those ...
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 ...
BLAST results showing a 280-base sequence of a chromosome 12 contig from rats BLAST results showing a 280-base sequence of a chromosome 12 contig from rats
The fates of duplicate genes The fates of duplicate genes
Video: Language Areas Animation

For a complete list of videos, visit our video library