Module1_Quiz

#_1. 
Select the jobs below that may use SQL in their work (select all that apply).

DBA
Data Scientist
Data Analyst
QA Engineer
Backend Developer



#_2. 
How does a data scientist and DBA differ in how they use SQL?
DBAs manage the databse for other user.



#_3. 
Which of the following statements are True of Entity Relationship Diagrams?

They are usually a representtion of a business process

They usually are represented in a visual format

They identify the Prigamry Keys

They shows you the relationships between tables.



#_4. 
Select the query below that will retrieve all columns from the customers tables

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 disgram 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 the 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 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 SQLm every SQL statement must contain?

SELECT