SQL Functions
Authored by Suheba Mubashir
Computers
Professional Development
Used 17+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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;
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The COUNT() function also counts the NULL values.
True
False
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In a column named "age", containing values 4, 5, 6, the SQL statement "SELECT SUM(age) FROM students;" will return,
3
15
0
1
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The MIN() function returns - - - in the given column.
the largest value
the last value
the total sum value
the smallest value
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The MAX() function returns - - - in the given column.
the largest value
the last value
the total sum value
the smallest value
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The average value of the given numeric column is calculated by using - - - function.
GETAVG()
FINDAVG()
AVG()
AVGVALUE()
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
