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 81 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
Wow, this really help

Laurenleakan

  • Member
  • Posts: 309
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Did you know?

Alzheimer's disease affects only about 10% of people older than 65 years of age. Most forms of decreased mental function and dementia are caused by disuse (letting the mind get lazy).

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

(A) Scratch test; patient is exposed to allergens through a light scratch on the skin; (B) Positive (A) Scratch test; patient is exposed to allergens through a light scratch on the skin; (B) Positive
Select the Code with the Highest Level of Specificity Select the Code with the Highest Level of Specificity
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.
Flow scattergrams showing results on the top set from a healthy donor and on the bottom set from a ... Flow scattergrams showing results on the top set from a healthy donor and on the bottom set from a ...
(A) Thumb slides to forehead in 2–3 rows, and along the eyebrow to the outer edge. (B) Press into ... (A) Thumb slides to forehead in 2–3 rows, and along the eyebrow to the outer edge. (B) Press into ...
Results of Mendel’s Experiments Results of Mendel’s Experiments
Video: A timeline of the teeth (Explained - No Audio)

For a complete list of videos, visit our video library