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 85 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

alexanderhamilton

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

« previous next »
 

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

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?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

A health history is essential in collecting subjective data about metabolic acidosis. A health history is essential in collecting subjective data about metabolic acidosis.
Lilly Martin Spencer’s Young Husband: First Marketing (1854). Note that passers-by are amused at thi Lilly Martin Spencer’s Young Husband: First Marketing (1854). Note that passers-by are amused at thi
Design Data for Various Packings Design Data for Various Packings
Columns With Papyriform And Bud Capitals, Hypostyle Hall, Great Temple Of Amun At Karnak Columns With Papyriform And Bud Capitals, Hypostyle Hall, Great Temple Of Amun At Karnak
A 16-input multiplexer is to be used to perform parallel-to-serial data conversion. Which of ... A 16-input multiplexer is to be used to perform parallel-to-serial data conversion. Which of ...
Satellite data showing net primary production. Productivity is coded as red (highest) down through o Satellite data showing net primary production. Productivity is coded as red (highest) down through o
Video: Pores and Ion Channels

For a complete list of videos, visit our video library