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 62 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
Excellent

nguyenhoanhat

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

HIV testing reach is still limited. An estimated 40% of people with HIV (more than 14 million) remain undiagnosed and do not know their infection status.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Examples of deep-sea corals found in the Sable Gully, 200 km off the coast of Nova Scotia. Examples of deep-sea corals found in the Sable Gully, 200 km off the coast of Nova Scotia.
Examples of internal controls. Examples of internal controls.
Examples of heart rhythms: sinus bradycardia. Examples of heart rhythms: sinus bradycardia.
How to find derivatives of trigonometric functions How to find derivatives of trigonometric functions
How to find the derivatives of inverse trigonometric functions (Part 1) How to find the derivatives of inverse trigonometric functions (Part 1)
How to integrate trigonometric functions containing sine and cosine with odd powers (Part 2) How to integrate trigonometric functions containing sine and cosine with odd powers (Part 2)
Video: B cells and antibodies

For a complete list of videos, visit our video library