FIT9132 PASS Week 10
Authored by Yiheng Cai
Information Technology (IT)
University
Used 8+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following returns the total number of rows in a table, including those where all columns are NULL?
COUNT(column_name)
COUNT(*)
SUM(1)
TOTAL_ROWS()
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does COUNT(DISTINCT column_name) return?
Total number of rows, including NULLs
Sum of all values in the column
Number of distinct non-NULL values in the column
Number of columns in the table
Maximum value in the column
3.
DRAG AND DROP QUESTION
1 min • 1 pt
Choose the correct execution order of SQL statement clauses:
SELECT -> (a) -> (b) -> (c) -> (d) -> (e)
4.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Which of the following statements about WHERE and HAVING are true?
WHERE filters rows before grouping.
HAVING filters groups after aggregation.
HAVING can reference aggregate functions.
WHERE can reference aggregate functions.
HAVING is always evaluated before GROUP BY.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which clause should you use to filter groups based on an aggregate condition?
WHERE
GROUP BY
HAVING
FILTER
6.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
Which of the following are valid SQL aggregate functions?
SUM
MIN
RANDOM
AVG
MAX
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Which of these are valid comparison operators for use with subqueries?
=
>
IN
LIKE
ANY
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?
