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 79 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!

phuda

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

« previous next »
 

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

Did you know?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

All computer systems perform four basic functions: input, processing, storage, and output. All computer systems perform four basic functions: input, processing, storage, and output.
Chromatography columns packed with various chromatography resins Chromatography columns packed with various chromatography resins
Hubbard’s Predication of Peak in U.S Oil Production with Actual Data Hubbard’s Predication of Peak in U.S Oil Production with Actual Data
Endocrine System: Facts, Functions and Diseases Endocrine System: Facts, Functions and Diseases
Finding derivatives of Trig Functions - pt 5 Finding derivatives of Trig Functions - pt 5
Histograms - Analysis and Data Histograms - Analysis and Data
Video: Ionic bonds - role of ions in the body

For a complete list of videos, visit our video library