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 80 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
Excellent

parshano

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

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?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

A subculture of employees who work at a medical practice A subculture of employees who work at a medical practice
Structures and Functions of the Eye Structures and Functions of the Eye
Remove all jewelry before performing service work on any vehicle. Remove all jewelry before performing service work on any vehicle.
Finding derivatives of Trig Functions - pt 2 Finding derivatives of Trig Functions - pt 2
Finding derivatives of Trig Functions - pt 3 Finding derivatives of Trig Functions - pt 3
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: Neural regulation of blood pressure - baroreceptor and chemoreceptor reflexes

For a complete list of videos, visit our video library