-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathweek4quiz.html
103 lines (69 loc) · 2.59 KB
/
week4quiz.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
96
97
98
99
100
101
102
103
<!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 4 Quiz</h2>
<!-- add a few paragraph lines to describe you -->
<p><h5> 1. Which of the following are supported in SQL when dealing with strings? (Select all that apply).</h5></p> <!-- where do you live? -->
<p>Answers:</p> <!-- Where studying/studied? -->
<p> Lower </p>
<p> Trim </p>
<p>Upper </p>
<p> Concatenate </p>
<p> Substring </p>
<p><h5> What will the result of the following statement be?
SELECT LEFT('You are beautiful.', 3)</h5></p>
<p>Answers:</p>
<p> u are beautiful</p>
<p><h5> 3. What is the results of the following query?
select * orders
where order_date = ‘2017-07-15’ </h5></p>
<p>Answers:</p>
<p> You won't get any results </p>
<p><h5> 4. Case statements can only be used for which of the following statements (select all that apply)?</h5></p>
<p>Answers:</p>
<p> Update </p>
<p> Delete </p>
<p> Insert </p>
<p>Select </p>
<p><h5> 5. Which of the following is false regarding views?</h5></p>
<p>Answers:</p>
<p> Views will remain after the database connection has ended </p>
<p><h5> 6. You are only allowed to have one condition in a case statement. True or false?</h5></p>
<p>Answers:</p>
<p> False </p>
<p><h5> 7. Select the correct SQL syntax for creating a view.</h5></p>
<p>Answers:</p>
<p> CREATE VIEW
customers AS
SELECT *
FROM customers
WHERE Name LIKE '%I' </p>
<p><h5> 8. Profiling data is helpful for which of the following? (Select all that apply)</h5></p>
<p>Answers:</p>
<p> Filter out unwanted data elements </p>
<p> Understanding your data </p>
<p><h5> 9. What is the most important step before beginning to write queries?</h5></p>
<p>Answers:</p>
<P> Understanding your data </p>
<p><h5> 10. When debugging a query, what should you always remember to do first?</h5></p>
<p>Answers:</p>
<p> Start simple and break it down first </p>
</body>
<footer>
<hr>
<!-- change the name to yours! -->
<code>Copyright (C) 2020 Mayank Pathak</code>
</footer>
</html>