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 71 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
Thanks for the timely response, appreciate it

milbourne11

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

« previous next »
 

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

Striking examples where high surface area releases heat. Striking examples where high surface area releases heat.
The Krapina remains may provide evidence of cannibalism by some Neadertals. The Krapina remains may provide evidence of cannibalism by some Neadertals.
Examples of Declarative and Nondeclarative Memory Tasks Examples of Declarative and Nondeclarative Memory Tasks
All computer systems perform four basic functions: input, processing, storage, and output. All computer systems perform four basic functions: input, processing, storage, and output.
Mechanisms to Explain the Effects of Massage Mechanisms to Explain the Effects of Massage
Please fully explain in detail Please fully explain in detail
Video: Sigmoidoscopy

For a complete list of videos, visit our video library