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 49 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
Wow, this really help

sultana.d

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

« previous next »
 

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
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.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

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 pathogens. Examples of pathogens.
One of the many functions of religion is providing emotional support. This photo was taken in ... One of the many functions of religion is providing emotional support. This photo was taken in ...
Examples of endocrine disorders. (A) A patient with exophthalmos, a symptom of hyperthyroidism ... Examples of endocrine disorders. (A) A patient with exophthalmos, a symptom of hyperthyroidism ...
Stronger threads are created by cold rolling a heat-treated bolt blank instead of cutting the ... Stronger threads are created by cold rolling a heat-treated bolt blank instead of cutting the ...
Examples of X-linked Immunodeficiencies Examples of X-linked Immunodeficiencies
Video: Language Areas Animation

For a complete list of videos, visit our video library