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 73 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

marict

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

« previous next »
 

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

Anti-aging claims should not ever be believed. There is no supplement, medication, or any other substance that has been proven to slow or stop the aging process.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

Graphic display of hypothetical results of a predator removal experiment. Graphic display of hypothetical results of a predator removal experiment.
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.
Using Controls to Monitor Results Using Controls to Monitor Results
The experimental design and results of Lester and Gorzalka (1988). On the third test, the female ... The experimental design and results of Lester and Gorzalka (1988). On the third test, the female ...
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
An example of DNA profile results for the 13 original CODIS STRs An example of DNA profile results for the 13 original CODIS STRs
Video: Nervous pathway to the Neuromuscular (NMJ)

For a complete list of videos, visit our video library