SQL Statement Part 3

What sql statement is used for finding the highest possible number in a field?

• MIN

• MAX

• AVERAGE

• SUM

Which of the following is the right way of using MIN SQL statement?

• SELECT (Salary)

  FROM Teachers

  MIN

• SELECT (Salary) MIN

  FROM Teacher

• SELECT MIN (Salary)

  FROM Teacher

• SELECT (Salary)

  FROM MIN Teacher

What SQL statement is being in finding students records that doesn't have information?

• Is Null

• Null

• Missing

• Blank

What SQL statement is used in adding all the records in a specific field?

• AVG

• MAX

• MIN

• SUM

This SQL statement is used to find the number of values in the specified field.

• SUM

• MAX

• COUNT

• AVG

Which of the following is the right way of using the SQL statement MAX?

• SELECT MAX (Salary)

  FROM Teacher

• SELECT (Salary) MAX

  FROM Teacher

• SELECT (Salary)

  FROM MAX Teacher

• SELECT (Salary)

  FROM Teacher MAX

Which SQL statement is used in computing for the average of the salary of the teacher?

• AVG

• MIN

• MAX

• SUM

Which of the following is the right way of using Is Null SQL statement?

• SELECT Age

  FROM Students

  Where Age Is Null

• SELECT Is Null Age

  FROM Students

• SELECT Age

  FROM Is Null Students

• SELECT Age

  FROM Students

  Where Is Null Age

Which of the following is the right way of using the SUM SQl statement?

• SELECT (Salary)

  FROM Teachers SUM

• SELECT SUM (Salary)

  FROM Teachers

• SELECT (Salary)

  FROM SUM Teachers

• SELECT (Salary) SUM

  FROM Teachers

Which of the following is the right way of using AVG SQL statement?

• SELECT AVG (Salary)

  FROM Teachers

• SELECT (Salary) AVG

  FROM Teachers

• SELECT (Salary)

  FROM AVG Teachers

• SELECT (Salary)

  FROM Teachers AVG