COUNT(field_name) tallies only those rows that contain a value; it ign – McqOptions

MCQOPTIONS

1.	COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.%!
A.	True
B.	False
Answer» B. False

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.%!