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 91 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
YES! Correct, THANKS for helping me on my review

ashely1112

  • Member
  • Posts: 347
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Did you know?

More than 50% of American adults have oral herpes, which is commonly known as "cold sores" or "fever blisters." The herpes virus can be active on the skin surface without showing any signs or causing any symptoms.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Multiple sclerosis (MS). (a) A disease characterized by the gradual development of small areas of ha Multiple sclerosis (MS). (a) A disease characterized by the gradual development of small areas of ha
Lab results Lab results
Carbon dioxide. This molecule exhibits a nonpolar bond and results in a linear and symmetrical ... Carbon dioxide. This molecule exhibits a nonpolar bond and results in a linear and symmetrical ...
Results Seen in Mono-Diff Tests Results Seen in Mono-Diff Tests
BLAST results showing a 280-base sequence of a chromosome 12 contig from rats BLAST results showing a 280-base sequence of a chromosome 12 contig from rats
phylogenetic results using the TCF7L2 transcripting mRNA sequence for the 4 listed taxa phylogenetic results using the TCF7L2 transcripting mRNA sequence for the 4 listed taxa
Video: Regulation of GFR: autoregulation via tubuloglomerular feedback, neural & hormonal regulation

For a complete list of videos, visit our video library