-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathweek2quiz.html
95 lines (69 loc) · 3.09 KB
/
week2quiz.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
<!doctype html>
<!-- this is a comment for human! -->
<html lang="en">
<header>
<!-- change the name to yours! -->
<title>SQL for Data-Science </title>
<!-- link to the master cascading stylesheet -->
<link rel="stylesheet" href="css/master.css">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="name" content="SQL for Data-science">
</header>
<body>
<!-- add the name for the website -->
<h1>SQL for Data-science Coursera Assignment Answers</h1>
<!-- add a section called "About Me" -->
<h2>Week 2 Quiz</h2>
<!-- add a few paragraph lines to describe you -->
<p><h5>1.Filtering data is used to do which of the following? (select all that apply).</h5></p> <!-- where do you live? -->
<p>Answers:</p> <!-- Where studying/studied? -->
<p> Narrows down the results of the data. </p>
<p>Reduces the strain on the client application </p>
<p>Reduce the time it takes to run the query </p>
<p> Removes unwanted data in a calculation </p>
<p> Helps you understand the contents of your data </p> <!-- current job or current school year? -->
<p><h5>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.</h5></p>
<p>Answers:</p>
<p>SELECT name
FROM Artists
WHERE name LIKE ‘K%’; </p>
<p><h5>3.A null and a zero value effectively mean the same thing. True or false? </h5></p>
<p>Answers:</p>
<p>False</p>
<p><h5>4.Select all that are true regarding wildcards</h5></p>
<p>Answers:</p>
<p> Wildcards take longer to run compared to a logical operator </p>
<p> Wildcards at the end of search patterns take longer to run </p>
<p><h5> 5. Select the statements below that ARE NOT true of the ORDER BY clause (select all that apply).</h5></p>
<p>Answers:</p>
<p> Cannot sort by a column not retrieved </p>
<p> Can be anywhere in the select statement </p>
<p><h5> 6. Select all of the valid math operators in SQL (select all that apply).</h5></p>
<p>Answers:</p>
<p>+ (addition) </p>
<p> - (subtraction) </p>
<p> / (division) </p>
<p> * (multiplication) </p>
<p><h5> 7. Which of the following is an aggregate function? (select all that apply).</h5></p>
<p>Answers:</p>
<p> MAX() </p>
<p>MIN() </p>
<p> Count() </p>
<p><h5> 8. Which of the following is true of GROUP BY clauses?</h5></p>
<p>Answers:</p>
<p> GROUP BY clauses can contain multiple columns </p>
<p> NULLs will be grouped together if your Group By column contains NULLs </p>
<p> Every column in your select statement must be present in a group by clause, except for aggregated calculations. </p>
<p><h5> 9. Select the true statement below.</h5></p>
<p>Answers:</p>
<P> HAVING filters after the data is grouped. </p>
<p><h5> 10. Which is the correct order of occurrence in a SQL statement?</h5></p>
<p>Answers:</p>
<p> select, from, where, group by, having </p>
</body>
<footer>
<hr>
<!-- change the name to yours! -->
<code>Copyright (C) 2020 Mayank Pathak</code>
</footer>
</html>