WorksheetsSQL Statement Part 3
Total questions: 10
Worksheet time: 8mins
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
