SQL Functions

The SQL statement to count distinct rows from a column is,

• select COUNT DISTINCT columnname AS total_rows from tablename;

• select (COUNT DISTINCT columnname) AS total_rows from tablename;

• select DISTINCT columnname AS total_rows from tablename;

• select COUNT (DISTINCT) AS total_rows from tablename;

The COUNT() function also counts the NULL values.

• True

• False

The SUM() function returns - - -

• some random values from the given column

• the total number of columns in the database

• the total number of tables in the given databases

• the total sum of a given numeric column

In a column named "age", containing values 4, 5, 6, the SQL statement "SELECT SUM(age) FROM students;" will return,

• 3

• 15

• 0

• 1

The MIN() function returns - - - in the given column.

• the largest value

• the last value

• the total sum value

• the smallest value

The MAX() function returns - - - in the given column.

• the largest value

• the last value

• the total sum value

• the smallest value

The average value of the given numeric column is calculated by using - - - function.

• GETAVG()

• FINDAVG()

• AVG()

• AVGVALUE()

The - - - function is used to round a floating point number to the given decimal numbers.

• ROUND()

• GETROUND()

• UPPER()

• DOROUND()

The SQL statement "SELECT CHAR_LENGTH('John');" will return,

• 1

• 2

• 3

• 4

Which one of the following is an Aggregate Functions?

• COUNT()

• LEN()

• CASE()

• NOW()