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 40 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
Excellent

abro1885

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

« previous next »
 

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Did you know?

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

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.

Summary of greenhouse experimental design and results Summary of greenhouse experimental design and results
An enlarged heart showing the results of cardiomyopathy. An enlarged heart showing the results of cardiomyopathy.
Results are shown for proteins denatured by two different environmental changes Results are shown for proteins denatured by two different environmental changes
Results of Mendel’s crosses using pea plants. The numbers represent the F2 plants showing a given ... Results of Mendel’s crosses using pea plants. The numbers represent the F2 plants showing a given ...
Results of a cross involving two genes located on the same chromosome Results of a cross involving two genes located on the same chromosome
Results of the serial dilution technique and subsequent culture of bacteria Results of the serial dilution technique and subsequent culture of bacteria
Video: Uterine (menstrual) cycle - phases

For a complete list of videos, visit our video library