Module 4 Quiz >> Week 4 >> SQL for Data Science
Module 4 Quiz TOTAL POINTS 10 1. Question 1 Which of the following are supported in SQL when dealing with strings? (Select all that apply) 1 point Substring Concatenate Upper Lower Trim 2. Question 2 What will the result of the following statement be? 1 SELECT SUBSTR(‘You are beautiful.’, 3) 1 point This will return an error You are beautiful. u are beautiful. beautiful. 3. Question 3 What are the results of the following query? 123 select * orders where order_date = ‘2017-07-15’ Additional information: Orders = integer Order_date = datetime 1 point You won’t get any results. You will get all the orders with an order date of 2017-07-15. You will get all of the orders. 4. Question 4 Case statements can only be used for which of the following statements (select all that apply)? 1 point Insert Select Delete Update 5. Question 5 Which of the following is FALSE regarding views? 1 point Views will remain after the database connection has ended Views can be used to encapsulate queries Views are stored in a query 6. Question 6 You are only allowed to have one condition in a case statement. True or false? 1 point True False 7. Question 7 Select the correct SQL syntax for creating a view. 1 point 12345 INSERT VIEW customers AS Select * FROM customers WHERE Name LIKE ‘%I’ 123456 CREATE VIEW customers AS SELECT * FROM customers WHERE Name LIKE ‘%I’ 12345 CREATE VIEW AS SELECT * FROM customers WHERE Name LIKE ‘%I’ 8. Question 8 Profiling data is helpful for which of the following? (Select all that apply) 1 point Joining tables together Filter out unwanted data elements Understanding your data 9. Question 9 What is the most important step before beginning to write queries? 1 point Deciding what should be done on the client application vs the RDMS Understanding your data Deciding what tables you want to join 10. Question 10 When debugging a query, what should you always remember to do first? 1 point Start simple and break it down first Start with the inner most query Start by examining the joins Make sure you didn’t miss any commas.
*Please Wait 15 Seconds To Get The Pdf Loaded