Answer these question bellows. 1. A flower shop wants to see every flower ordered, but each flower should only show once. Which SQL statement will fulfill that need? A. SELECT UNIQUE flowername FROM flowers B. SELECT flowername FROM flowers DISTINCT C. SELECT DISTINCT flowername FROM flowers D. SELECT TOP 1 flowername FROM flowers 2. A view named vw_customers exist with a firstname and lastname column from the customers’ table. The customerid field needs to be added to the view and should be the first field in the view. Which SQL statement makes the needed change to the view? A. DROP VIEW vw_customers CREATE VIEW vw_customers AS SELECT customerid, firstname, lastname FROM customers B. ALTER VIEW vw_customers AS SELECT customerid, firstname, lastname FROM customers C. The result of the execution of a query. D. CREATE VIEW vw_customers AS SELECT customerid, firstname, lastname FROM customers 3. You have been tasked to delete a row from a database table. You execute the following SQL statement without a WHERE clause: DELETE FROM table_name What will be the result of executing the statement above without a WHERE clause? A. No records will be deleted. B. All records will be deleted. C. An error message will be returned. D. The first record will be deleted by default. 4. Which SQL statements, as part of creating a column in a table, will format the orderdate field in YYYY-MM-DD HH:MI:SS format? (Choose two) A. orderdate DATETIME B. orderdate TIMESTAMP C. orderdate DATE D. orderdate SMALLDATETIME 5. Match each JOIN type to its function. To answer, drag the JOIN type from the column on the left to its correct function on the right. Each JOIN type may be used once, more than once, or not at all. a. RIGHT OUTER JOIN: Returns all rows from the right table, even if there are no matches in the left table. b. LEFT OUTER JOIN: Returns all rows from the left table, even if there are no matches in the right table. c. INNER JOIN: Returns rows when there is at least one match in both tables. d. FULL OUTER JOIN: Returns rows when there is a match in one of the tables.