Module 2 Quiz >> Week 2 >> SQL for Data Science

Module 2 Quiz >> Week 2 >> SQL for Data Science

Module 2 Quiz TOTAL POINTS 10 1. Question 1 Filtering data is used to do which of the following? (select all that apply) 1 point Reduce the time it takes to run the query Helps you understand the contents of your data Narrows down the results of the data. Removes unwanted data in a calculation Reduces the strain on the client application 2. Question 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. 1 point 123 SELECT name FROM Artists WHERE name LIKE ‘%K’; 123 SELECT name FROM Artists WHERE name LIKE ‘K%’; 123 SELECT name FROM Artists WHERE name LIKE ‘%K%’; 123 SELECT name FROM Artists WHERE name IN ‘K%’; 3. Question 3 A null and a zero value effectively mean the same thing. True or false? 1 point True False 4. Question 4 Select all that are true regarding wildcards (Select all that apply.) 1 point Wildcards at the end of search patterns take longer to run Wildcards can be used for non-text data items Wildcards take longer to run compared to a logical operator 5. Question 5 Select the statements below that ARE NOT true of the ORDER BY clause (select all that apply). 1 point It’s only applied to the column names it directly precedes Can take the name of one or more columns Can be anywhere in the select statement Cannot sort by a column not retrieved 6. Question 6 Select all of the valid math operators in SQL (select all that apply). 1 point + (addition) * (multiplication) – (subtraction) / (division) ^ (exponents) 7. Question 7 Which of the following is an aggregate function? (select all that apply) 1 point COUNT() DISTINCT() MIN() MAX() 8. Question 8 Which of the following is true of GROUP BY clauses? (Select all that apply.) 1 point Every column in your select statement may/can be present in a group by clause, except for aggregated calculations. GROUP BY clauses can contain multiple columns NULLs will be grouped together if your Group By column contains NULLs 9. Question 9 Select the true statement below. 1 point HAVING filters after the data is grouped. WHERE filters after the data is grouped 10. Question 10 Which is the correct order of occurrence in a SQL statement? 1 point select, from, where, group by, having select, from, where, order by, having select, group by, from, where, having select, having, where, group by

*Please Wait 15 Seconds To Get The Pdf Loaded

Leave a Comment