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

parshano

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

The nitrogen cycle. Numbers represent fluxes as 1012 g N per year (data from Schlesinger 1991, after The nitrogen cycle. Numbers represent fluxes as 1012 g N per year (data from Schlesinger 1991, after
A Biologist at Work A Biologist at Work
Work and Gender: Women at Work in India Work and Gender: Women at Work in India
Business Intelligence, Analytics, and Data Science: A Managerial Perspective, 4th Edition Business Intelligence, Analytics, and Data Science: A Managerial Perspective, 4th Edition
Cell parts and their functions Cell parts and their functions
Where do Psychological Practitioners Work? Where do Psychological Practitioners Work?
Video: Acid-base imbalances - compensation of metabolic acidosis and alkalosis

For a complete list of videos, visit our video library