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 89 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
Gracias!

mjenn52

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

« previous next »
 

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

If you could remove all of your skin, it would weigh up to 5 pounds.

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

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.

Examples of the results of sexual selection, a type of natural selection. Examples of the results of sexual selection, a type of natural selection.
Graphic display of hypothetical results of a predator removal experiment. Graphic display of hypothetical results of a predator removal experiment.
An enlarged heart showing the results of cardiomyopathy. An enlarged heart showing the results of cardiomyopathy.
Cyanosis as shown here at the patient’s fingertips results from a lack of oxygen in the tissues Cyanosis as shown here at the patient’s fingertips results from a lack of oxygen in the tissues
To help make good electrical contact with the terminals without doing any harm, select the ... To help make good electrical contact with the terminals without doing any harm, select the ...
Distribution of skin color as measured by a reflectometer at a wavelength of 685 nm. The results are Distribution of skin color as measured by a reflectometer at a wavelength of 685 nm. The results are
Video: Introduction to Heart Attacks

For a complete list of videos, visit our video library