Jenna Is Working on a Database That Stores a Company's

question 73

Multiple Choice

Jenna is working on a database that stores a company's invoices. The database includes a Table called Invoices, which has a column called outBalances that shows all outstanding balances. Jenna's boss has asked her to design a query that calculates the numerical mean of all outstanding balances. Which function should Jenna use on the outBalances column to help her complete this task?

• A) Avg
• B) Sum
• C) Count
• D) Max

---

Definitions:

Values

Data items represented in software or memory, can be of various types including integer, float, string, or boolean.

Primitive Types

Primitive types are the most basic data types provided by a programming language, such as int, float, and char in C and C++, directly holding values.

Built-in Types

Predefined data types that are available in a programming language, such as integers, booleans, and floating-point numbers.

Escape Character

A character used in string literals to signify that the next character has a special meaning or should be interpreted differently.