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

bimper21

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

« previous next »
 

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

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.

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?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

New results from NASA's NEOWISE survey New results from NASA's NEOWISE survey
Pneumothorax. Figure illustrates how puncture of thoracic wall and tearing of pleural membrane allow Pneumothorax. Figure illustrates how puncture of thoracic wall and tearing of pleural membrane allow
Reduced mobility in late adulthood often results in more limited activities and smaller social ... Reduced mobility in late adulthood often results in more limited activities and smaller social ...
Select Signs and Symptoms of Feeding and Eating Disorders Select Signs and Symptoms of Feeding and Eating Disorders
Select the proper adapter for the compression gauge. The threads on the adapter should match those ... Select the proper adapter for the compression gauge. The threads on the adapter should match those ...
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: Functional zones in a mitochondrion

For a complete list of videos, visit our video library