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 55 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
Gracias!

emsimon14

  • Member
  • Posts: 344
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?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

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?

If you could remove all of your skin, it would weigh up to 5 pounds.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Examples of ICD-10-CM Codes with Varying Numbers of Characters Examples of ICD-10-CM Codes with Varying Numbers of Characters
Endocrine Glands/Organ Functions Endocrine Glands/Organ Functions
Examples of SOAP Note entries. Examples of SOAP Note entries.
Examples of Capsules Examples of Capsules
Finding derivatives of Trig Functions - pt 6 Finding derivatives of Trig Functions - pt 6
Examples of sensory receptors. Examples of sensory receptors.
Video: Wound Cultures

For a complete list of videos, visit our video library