Answer these question bellows. 1. This query statement is run on the table. SELECT Address1 + ' ' + Address2 FROM Locations Location Main Warehouse Sales Address1 3 Main St 45 Stockman St 555 Shoreline Dr Address2 Suite 101 Suite 2 For each statement, indicate Yes if the statement is true and No if the statement is false. a. The plus signs should be ampersands. (NO) b. The locations will show in the results. (NO) c. Plus signs are used to concatenate strings of data in a SELECT statement. (YES) d. The location field in not used in the SELECT statement, thus is will not be shown in the results.(YES) 2. This query is run on the table. UPDATE Products SET Price 49.99 WHERE (Category = 'Shirt' AND Color = 'Blue') ID 1 2 3 Clothing Shirt Shirt Pants How many items will update? A. 1 B. 2 C. 0 D. 3 Color Red Blue Blue Price 44.99 44.99 44.99 3. A report writer is trying to retrieve all cities that had total sales of at least $50000. The state, city, and amount fields should be returned. Which statement fulfills that needed? A. SELECT state, city, SUM (salesamount) FROM sales GROUP BY state, city WHERE SUM (salesamount) >= 50000 B. SELECT state, city, SUM (salesamount) FROM sales WHERE salesamount > = 50000 GROUP BY state, city C. SELECT state, city, SUM (salesamount) HAVING SUM(salesamount) >= 50000 FROM sales GROUP BY state, city D. SELECT state, city, SUM (salesamount) FROM sales HAVING salesamount >= 50000 GROUP BY state, city 4. Evaluate the following query: SELECT e2.EmployeelD ,e2.LastName ,e1.LastName AS 'Supervisor' FROM Employees as e1 JOIN Employees as e2 on e2.Reports To= e1.EmployeelD Which type of join best describes the join being used for that query? A. Self-join B. Left outer join C. Cartesian product D. Right outer join 5. What are the main benefits of using the proper data types to define columns when creating a table in a database, rather than just assigning VARCHAR as a data type to all columns? (Choose two) A. Avoiding putting a constraint where one is not needed. B. Fewer restrictions on entering data. C. The ability to use values for calculations. D. More efficient data storage.