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 38 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
:D TYSM

Chelseyj.hasty

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

« previous next »
 

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Protobionts and their lifelike functions Protobionts and their lifelike functions
The immune system has several different components that work in concert. The immune system has several different components that work in concert.
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.
Multitasking at work Multitasking at work
Proteins are built from amino acids Proteins are built from amino acids
What is the maximum velocity (in km/s) of a photoelectron emitted from a surface whose work ... What is the maximum velocity (in km/s) of a photoelectron emitted from a surface whose work ...
Video: Language Areas Animation

For a complete list of videos, visit our video library