-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathweek1quiz.html
90 lines (66 loc) · 2.77 KB
/
week1quiz.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
<!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 1 Quiz</h2>
<!-- add a few paragraph lines to describe you -->
<p><h5>1.Select the jobs below that may use SQL in their work (select all that apply).</h5></p> <!-- where do you live? -->
<p>Answers:</p> <!-- Where studying/studied? -->
<p>Data Analyst</p>
<p>QA Engineer</p>
<p>Backend Developer</p>
<p>DBA</p>
<p>Data Scientist</p> <!-- current job or current school year? -->
<p><h5>2.How does a data scientist and DBA differ in how they use SQL?</h5></p>
<p>Answers:</p>
<p>DBAs manage the database for other users</p>
<p><h5>3.Which of the following statements are true of Entity Relationship (ER) Diagrams?</h5></p>
<p>Answers:</p>
<p>They identify the Primary Keys</p>
<p>They are usually a representation of a business process.</p>
<p>They show you the relationships between tables.</p>
<p>They usually are represented in a visual format. </p>
<p><h5>4.Select the query below that will retrieve all columns from the customers table.</h5></p>
<p>Answers:</p>
<p>SELECT * FROM customers</p>
<p><h5>5.Select the query that will retrieve only the Customer First Name, Last Name, and Company.</h5></p>
<p>Answers:</p>
<p>SELECT
FirstName,
LastNameE,
Company
FROM
Customers</p>
<p><h5>6.The ER diagram below is depicting what kind of relationship between the EMPLOYEES and CUSTOMERS tables?</h5></p>
<p>Answers:</p>
<p>One-to-Many</p>
<p><h5>7.The data model depicted in the ER diagram below could be described as a _______________.</h5></p>
<p>Answers:</p>
<p>Relational Model</p>
<p><h5>8.When using the "CREATE TABLE" command and creating new columns for that table, which of the following statements is true?</h5></p>
<p>Answers:</p>
<p>You must assign a data type to each column</p>
<p><h5>9.Look at the values in the two columns below. Based on the values in each column, which column could potentially be used as a primary key?</h5></p>
<p>Answers:</p>
<P>column 1</p>
<p><h5>10.In order to retrieve data from a table with SQL, every SQL statement must contain?</h5></p>
<p>Answers:</p>
<p>SELECT</p>
</body>
<footer>
<hr>
<!-- change the name to yours! -->
<code>Copyright (C) 2020 Mayank Pathak</code>
</footer>
</html>