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 39 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
Wow, this really help

rachel

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

« previous next »
 

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Helping maintain accurate patient records is a critical part of the medical assistant's work. Helping maintain accurate patient records is a critical part of the medical assistant's work.
How do men who work in traditionally feminine nurturng jobs and women who work in jobs that give ... How do men who work in traditionally feminine nurturng jobs and women who work in jobs that give ...
How to find the domain of a natural logarithmic functions (Part 2) How to find the domain of a natural logarithmic functions (Part 2)
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
Finding derivatives of Trig Functions - pt 6 Finding derivatives of Trig Functions - pt 6
Survivorship curves. Blue lines are theoretical curves. Red dots are data from field studies. Survivorship curves. Blue lines are theoretical curves. Red dots are data from field studies.
Video: Summary of glucose catabolism

For a complete list of videos, visit our video library