Answer these question bellows. 1. A database administrator needs to give the following permissions on the following objects: a. Execute permissions on the sp_current_sales stored procedure to the inside_sales group. b. The ability to run the vw_sales_today view to the sales manager role and and allow the manager to allow others to see the view as well. Using the dropdown lists, choose the correct syntax for each statement. 1) What statement gives the inside_sales team the ability to execute the sp_current_sales stored procedure? Answer:(GRANT EXECUTE ON sp_current_sales TO inside_sales) 2) Which statement allows the sales_manager role to run the vw_sales_today view and allow the manager to give others the same permission? Answer: (GRANT SELECT ON vw_sales_today TO sales_manager WITH GRANT OPTION) 2. A sales analyst needs to see who placed orders, the order ID of the order, its subtotal, and a sales tax, which is 5% of the subtotal. The sales tax column does not exists. Only customers who placed orders should be seen. Which SQL statement satisfies all the requirements for the sales analyst? A. SELECT firstname, lastname, subtotal, subtotal* .05 as sales_tax FROM customers INNER JOIN orders on customers.customerid = orders.customerid B. SELECT firstname, lastname, subtotal, subtotal * .05 as sales_tax FROM customers LEFT OUTER JOIN orders on customers.customerid = orders.customerid C. SELECT firstname, lastname, subtotal, subtotal * 1.05 as sales_tax FROM customers INNER JOIN orders on customers.customerid = orders.customerid D. SELECT firstname, lastname, subtotal, subtotal 1* .05 as sales_tax FROM customers LEFT OUTER JOIN orders on customers.customerid = orders.customerid 3. You want to create a phone directory for your organization using a database table. Each record must be uniquely identified with a numeric value. The phone directory will contain the following information for each member:  First name  Last name  Date of birth  Phone number  Photo How should the SQL query be ordered to create the table? Answer: CREATE TABLE [dbo].[Member] ( [Id] INT NOT NULL PRIMARY KEY [FirstName] NCHAR (255) NULL, [LastName] NCHAR (255) NULL, [DateOfBirth] DATE NULL, [PhoneNumber] NCHAR (10) NULL, [Photo] IMAGE NULL ) 4. Which is a major difference between a stored procedure and a function? A. A Function must be compiled every time it is called. B. A Stored Procedure must be compiled every time it is called. C. Functions cannot be called from a Stored Procedure, but a Stored Procedure can be called from a Function. D. A Function can have both input/output parameters, but a Stored Procedure can only have input parameters. 5. Evaluate the following table of data: ID 1 2 3 4 LastName Gomez Parker Smith Tang What is the result of the following query: SELECT MAX(Salary) from employee. A. 83000 B. 1 C. Gomez D. 38000 Salary 83000 38000 70000 68000