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 65 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!

Dnite

  • Member
  • Posts: 297
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

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?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Examples of cell types derived from ectoderm, mesoderm, and endoderm. Examples of cell types derived from ectoderm, mesoderm, and endoderm.
Examples of USP labels Source: Courtesy of Novartis Pharmaceuticals Corporation and Mallinckrodt Pha Examples of USP labels Source: Courtesy of Novartis Pharmaceuticals Corporation and Mallinckrodt Pha
Examples of indirect care Examples of indirect care
Styles of Coping and Examples from the Brief COPE Inventory Styles of Coping and Examples from the Brief COPE Inventory
Protein Evolution: Myoglobin and Hemoglobin as Examples Protein Evolution: Myoglobin and Hemoglobin as Examples
Advanced functions application Advanced functions application
Video: Renal Failure

For a complete list of videos, visit our video library