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 37 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
YES! Correct, THANKS for helping me on my review

dantucker

  • Member
  • Posts: 346
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Many European Americans are involved in ethnic work, attempting to maintain an identity more precise ... Many European Americans are involved in ethnic work, attempting to maintain an identity more precise ...
How to find the domain and range of natural logarithmic functions (Part 1) How to find the domain and range of natural logarithmic functions (Part 1)
Finding derivatives of Trig Functions - pt 2 Finding derivatives of Trig Functions - pt 2
Stomach functions Stomach functions
Gamete genotype frequencies calculated from genetic linkage data Gamete genotype frequencies calculated from genetic linkage data
Ribosome structure and tRNA-binding sites interpreted from cryo-EM–generated data Ribosome structure and tRNA-binding sites interpreted from cryo-EM–generated data
Video: B cells and antibodies

For a complete list of videos, visit our video library