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

cassie_ragen

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

« previous next »
 

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Examples of herpes zoster. Examples of herpes zoster.
Bulging Eyes Of The Tarsier Provide Insight Into Evolution Of Human Vision Bulging Eyes Of The Tarsier Provide Insight Into Evolution Of Human Vision
Examples of pathogens. Examples of pathogens.
The medical assistant will provide patient education regarding the daily use of diabetic glucose ... The medical assistant will provide patient education regarding the daily use of diabetic glucose ...
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 manual exfoliation tools: loofah, brushes, ayate cloth, and sisal mitt. Examples of manual exfoliation tools: loofah, brushes, ayate cloth, and sisal mitt.
Video: Insulin (glucose uptake by body cells), glycogenesis and lipogenesis

For a complete list of videos, visit our video library