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 27 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

carlsona147

  • Member
  • Posts: 341
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

The senior population grows every year. Seniors older than 65 years of age now comprise more than 13% of the total population. However, women outlive men. In the 85-and-over age group, there are only 45 men to every 100 women.

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

For ice massage, ice is frozen in a cylindrical container or a paper cup (A). The top half of the cu For ice massage, ice is frozen in a cylindrical container or a paper cup (A). The top half of the cu
Medical assistants perform many functions in a physician's office or a clinic. Medical assistants perform many functions in a physician's office or a clinic.
Functions and Properties of Blood Functions and Properties of Blood
Examples of Sensory Receptors Examples of Sensory Receptors
Increasing/decreasing Functions Increasing/decreasing Functions
Examples of animal digestive systems. Examples of animal digestive systems.
Video: Effect of blood chemistry - stimuli, hyperventilation response and hypoventilation response

For a complete list of videos, visit our video library