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 51 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
Great answer, keep it coming :)

mammy1697

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Did you know?

According to the Migraine Research Foundation, migraines are the third most prevalent illness in the world. Women are most affected (18%), followed by children of both sexes (10%), and men (6%).

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

The functions of species richness. The functions of species richness.
Cylinder 1 slit signals the computer the piston position for cylinder 1. The 1-degree slits provide ... Cylinder 1 slit signals the computer the piston position for cylinder 1. The 1-degree slits provide ...
How to find the derivatives of inverse hyperbolic functions How to find the derivatives of inverse hyperbolic functions
Cows being raised for beef are often confined to feedlots, where they may be treated with antibiotic Cows being raised for beef are often confined to feedlots, where they may be treated with antibiotic
Range for Functions Range for Functions
Finding derivatives of Exponential functions - pt 2 Finding derivatives of Exponential functions - pt 2
Video: Mitochondrial Structure & ETC Protein Complexes (Protein Complexes and Electron Transport)

For a complete list of videos, visit our video library