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

Jossy

  • Member
  • Posts: 336
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

The Types of Functions of the T Cells The Types of Functions of the T Cells
Functions of white blood cells. Functions of white blood cells.
Examples of b-turns Examples of b-turns
Functions of Vitamin D Vitamin D Helps Bone Health by Regulating Calcium and Phosphorus Functions of Vitamin D Vitamin D Helps Bone Health by Regulating Calcium and Phosphorus
Brain functions are lateralized Brain functions are lateralized
Functions of the Stomach Functions of the Stomach
Video: Cardiac conductile cells

For a complete list of videos, visit our video library