Module2_Quiz

#_1
Filtering data is used to do which of the following? (select all that apply)

Narrows down the results of the data.
Removes unwanted data in a calculation
Reduce the time it takes to run the query
Helps you understand the contents of your data
Reduces the strain on the client application



#_2
You are doing an analysis on musicians that start with the letter “K”. 
Select the correct query that would retrieve only the artists whose name starts with this letter.

SELECT name
FROM Artists
WHERE name LIKE ‘K%’;



#_3
A null and a zero value effectively mean the same thing. True or false?

False.

0 is numeric value.
Null is absence of data.



#_4
Select all that are true regarding wildcards

Wildcards take longer to run compared to a logical operator
Wildcards at the end of search patterns take longer to run



#_5
Select the statements below that ARE NOT true of the ORDER BY clause 
(select all that apply).

Cannot sort by a column not retrieved
Can be anywhere in the select statement



#_6
Select all of the valid math operators in SQL (select all that apply).

- (subtraction)
+ (addition)
/ (division)
* (multiplication)



#_7
Which of the following is an aggregate function? (select all that apply)

MAX()
MIN()
COUNT()



#_8
Which of the following is true of GROUP BY clauses?

Every column in your select statement must be present in a group by clause, except for aggregated calculations.
NULLs will be grouped together if your Group By column contains NULLs
GROUP BY clauses can contain multiple columns



#_9.
Select the true statement below.

HAVING filters after the data is grouped.



#_10.

Which is the correct order of occurrence in a SQL statement?

select, from, where, group by, having