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 87 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
Excellent

hollysheppard095

  • Member
  • Posts: 339
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

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

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

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?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Effects of Estradiol and Testosterone on Interfemale Aggression in Rats (Based on data from van de P Effects of Estradiol and Testosterone on Interfemale Aggression in Rats (Based on data from van de P
The gaping hole in the destroyer USS Cole, in the port of Aden, Yemen, was the work of suicide bombe The gaping hole in the destroyer USS Cole, in the port of Aden, Yemen, was the work of suicide bombe
Work and Gender: Women at Work in India Work and Gender: Women at Work in India
How to integrate trigonometric functions containing even powers (Question 1) How to integrate trigonometric functions containing even powers (Question 1)
Demographic Data for Nigeria Demographic Data for Nigeria
Gamete genotype frequencies calculated from genetic linkage data Gamete genotype frequencies calculated from genetic linkage data
Video: EpiPen Animation (Part 1)

For a complete list of videos, visit our video library