Which statement is true about aggregate functions?
A.
The AVG function implicitly converts NULLS to zero
B.
The MAX and MIN functions can be used on columns with character data types
C.
Aggregate functions can be used in any clause of a SELECT statement
D.
Aggregate functions can be nested to any number of levels
The Answer Is:
B
This question includes an explanation.
Explanation:
B: True. The MAX and MIN functions can be applied to columns with character data types. These functions will return the highest or lowest values in a set of rows, based on alphabetical order for character data. This allows these aggregate functions to be versatile and useful across different data types, including numerical, date, and character types.
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"