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 42 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
Great answer, keep it coming :)

sultana.d

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

« previous next »
 

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Crossing Over Results in Genetic Recombination p1 Crossing Over Results in Genetic Recombination p1
An enlarged heart showing the results of cardiomyopathy. An enlarged heart showing the results of cardiomyopathy.
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.
Are the resutls from the glucose strip test consistent with the results obtained from the ... Are the resutls from the glucose strip test consistent with the results obtained from the ...
National Sleep Foundation Survey Results National Sleep Foundation Survey Results
The F1 and F2 results of crosses Sturtevant The F1 and F2 results of crosses Sturtevant
Video: Conjunctivitis

For a complete list of videos, visit our video library