SELECT 2
Authored by Halyna Melnyk
Computers
Professional Development
Used 5+ 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 clause _________________ indicates the tables you want to query and table operators like joins if applicable
FROM
SELECT
WHERE
GROUP BY
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
The clause _________________ filters rows based on a predicate. Only rows for which the predicate evaluates to true are returned. Rows for which the predicate evaluates to false or an unknown state are not returned.
FROM
SELECT
WHERE
GROUP BY
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The clause _________________ defines a group for each distinct combination of values from the input tables columns in the grouping list.
FROM
SELECT
WHERE
GROUP BY
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
This phase is responsible for filtering data based on a predicate, but it is evaluated after the data has been grouped.
HAVING
ORDER BY
WHERE
GROUP BY
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
This phase is responsible for ordering data based on ascending or descending order.
HAVING
ORDER BY
WHERE
GROUP BY
6.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
What are the 2 query clauses that enable you to filter data based on predicates?
SELECT
GROUP BY
ORDER BY
WHERE
HAVING
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which 'aggregate function' statement will return the numerical sum of all values in one column or more?
COUNT(column_name)
SUM(column_name)
DISTINCT(column_name)
AVG(column_name)
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
