This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: In an SQL query, the built-in functions SUM and AVG work with columns containing data of which of ... (Read 83 times)

CQXA

  • Hero Member
  • *****
  • Posts: 546
on: Jul 7, 2018
In an SQL query, the built-in functions SUM and AVG work with columns containing data of which of the following data types?
 
  A) Integer
  B) Numeric
  C) Char
  D) Both A and B are correct

Question 2

A ________ is used to limit the possible values of a foreign key.
 
  A) composite key
  B) surrogate key
  C) functional dependency
  D) referential integrity constraint


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

upturnedfurball

  • Sr. Member
  • ****
  • Posts: 334
Reply #1 on: Jul 7, 2018
Answer to Question 1

D

Answer to Question 2

D


CQXA

  • Member
  • Posts: 546
Reply 2 on: Jul 7, 2018
Gracias!

lindahyatt42

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

« previous next »
 

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Bayliss and Starling discovered the mechanism by which the small intestine and pancreas work togethe Bayliss and Starling discovered the mechanism by which the small intestine and pancreas work togethe
The Journey to Work, Philadelphia, 1850 The Journey to Work, Philadelphia, 1850
The Biological Functions of Nucleic Acids: A Preview of Molecular Biology The Biological Functions of Nucleic Acids: A Preview of Molecular Biology
Inferring Productivity from Data on Output and Factor Accumulation Inferring Productivity from Data on Output and Factor Accumulation
Demographic Data for India Demographic Data for India
Functions applications Functions applications
Video: Glomerular filtrate rate: pressures that affect GFR, NFP & GFR and blood composition

For a complete list of videos, visit our video library