-
Notifications
You must be signed in to change notification settings - Fork 7
/
Module1Quiz.txt
44 lines (35 loc) · 1.49 KB
/
Module1Quiz.txt
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
1. Select the jobs below that may use SQL in their work (select all that apply).
Data Scientist, QA Engineer, Backend Developer, DBA, Data Analyst
2. How does a data scientist and DBA differ in how they use SQL?
DBAs manage the database for other users.
3. Which of the following statements are true of Entity Relationship (ER) Diagrams?
They usually are represented in a visual format.
They show you the relationships between tables.
They identify the Primary Keys
They are usually a representation of a business process.
4. Select the query below that will retrieve all columns from the customers table.
SELECT * FROM customers
5. Select the query that will retrieve only the Customer First Name, Last Name, and Company.
SELECT
FirstName
,LastName
,Company
FROM customers
6. The ER diagram below is depicting what kind of relationship between the EMPLOYEES and CUSTOMERS tables?
One-to-many
7. The data model depicted in the ER diagram below could be described as a _______________.
Relational Model
8. When using the "CREATE TABLE" command and creating new columns for that table, which of the following statements is true?
You must assign a data type to each column
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?
Column 1 Column 2
5 2
6 4
1 5
2 5
34 32
8 6
9 4
Column 1
10. In order to retrieve data from a table with SQL, every SQL statement must contain?
SELECT