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

frankwu0507

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

Everyone has one nostril that is larger than the other.

(a) Feeding by bear on salmon results in large allochthonous inputs of nutrients into (b) the forest (a) Feeding by bear on salmon results in large allochthonous inputs of nutrients into (b) the forest
New results from NASA's NEOWISE survey New results from NASA's NEOWISE survey
Aneurysm. Photograph of the aorta, the large blood vessel arising from the heart, with a large bulge Aneurysm. Photograph of the aorta, the large blood vessel arising from the heart, with a large bulge
Sample root cause analysis: Duplicate dose of a narcotic analgesic. Sample root cause analysis: Duplicate dose of a narcotic analgesic.
Many diesel fuel additives increase the cetane rating which results in improved fuel economy. Many diesel fuel additives increase the cetane rating which results in improved fuel economy.
The results of a cytogenetic survey of over 4,000 miscarriages show a wide variation in how often sp The results of a cytogenetic survey of over 4,000 miscarriages show a wide variation in how often sp
Video: Methods that regulate pH

For a complete list of videos, visit our video library