*$_Which of the following are the five built-in functions provided by – McqOptions

MCQOPTIONS

1.	*$_Which of the following are the five built-in functions provided by SQL??
A.	COUNT, SUM, AVG, MAX, MIN
B.	SUM, AVG, MIN, MAX, MULT
C.	SUM, AVG, MULT, DIV, MIN
D.	SUM, AVG, MIN, MAX, NAME
Answer» B. SUM, AVG, MIN, MAX, MULT

Discussion

No Comment Found

Related MCQs

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.~!
To establish a range of values, < and > can be used.~!
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.~!
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.~!
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.~!
Indexes can usually be created for both primary and secondary keys.~!
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.%!
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.%!
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.%!
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.%!