This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain how NULLS are treated by Aggregate functions. Provide examples. What will be an ideal ... (Read 58 times)

justinmsk

  • Hero Member
  • *****
  • Posts: 524
on: Jul 7, 2018
Explain how NULLS are treated by Aggregate functions. Provide examples.
 
  What will be an ideal response?

Question 2

An operation such as login, read, perform, I/O or execute that is performed by the subject on or with an object is the _________ audit record field.
 
  A. resource-usage  B. subject
 
  C. object  D. action


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

akpaschal

  • Sr. Member
  • ****
  • Posts: 342
Reply #1 on: Jul 7, 2018
Answer to Question 1

Aggregate functions ignore nulls. They are not included in the SUM, MAX, MIN, or AVG. This probably has the most effect on averages. An average consists of the SUM of the values divided by the number of rows. Rows with NULLS are not counted, which effects the value of the average.

Answer to Question 2

D


justinmsk

  • Member
  • Posts: 524
Reply 2 on: Jul 7, 2018
:D TYSM

parshano

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

« previous next »
 

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

In most climates, 8 to 10 glasses of water per day is recommended for adults. The best indicator for adequate fluid intake is frequent, clear urination.

The functions of species richness. The functions of species richness.
For ice massage, ice is frozen in a cylindrical container or a paper cup (A). The top half of the cu For ice massage, ice is frozen in a cylindrical container or a paper cup (A). The top half of the cu
Diagnostic Imaging Procedures and Conditions Diagnosed or Treated Cont Diagnostic Imaging Procedures and Conditions Diagnosed or Treated Cont
Examples of endocrine disorders. (B) A patient with a goiter. Examples of endocrine disorders. (B) A patient with a goiter.
Examples of Personalized Medicine Drugs and Diagnostics Examples of Personalized Medicine Drugs and Diagnostics
Organs of the human male reproductive system, their functions, and locations. Organs of the human male reproductive system, their functions, and locations.
Video: Introduction to Heart Attacks

For a complete list of videos, visit our video library