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 72 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
YES! Correct, THANKS for helping me on my review

nathang24

  • Member
  • Posts: 314
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Examples of ICD-10-CM Codes with Varying Numbers of Characters Examples of ICD-10-CM Codes with Varying Numbers of Characters
How to integrate trigonometric functions containing sine and cosine with odd powers (Part 1) How to integrate trigonometric functions containing sine and cosine with odd powers (Part 1)
Dramatic growth of algae in water treated with phosphate Dramatic growth of algae in water treated with phosphate
Examples of Ophthalmic Examples of Ophthalmic
Functions and Properties of Blood Functions and Properties of Blood
Finding derivatives of Trig Functions - pt 5 Finding derivatives of Trig Functions - pt 5
Video: Glucagon (glycogenolysis and gluconeogenesis)

For a complete list of videos, visit our video library