Which statement correctly defines a view named "SalesSummary" that selects the total sales amount for each product category from a table called "SalesData"?Question 6Answera.CREATE VIEW SalesSummary SELECT ProductCategory, SUM(SalesAmount) AS TotalSales FROM SalesData;b.DEFINE VIEW SalesSummary ASSELECT SUM(SalesAmount), ProductCategoryFROM SalesDataGROUP BY ProductCategory;c.CREATE VIEW SalesSummary (TotalSales, ProductCategory)AS SELECT SUM(SalesAmount), ProductCategoryFROM SalesDataGROUP BY ProductCategory;d.CREATE VIEW SalesSummary ASSELECT ProductCategory, SUM(SalesAmount) AS TotalSales FROM SalesDataGROUP BY ProductCategory;

You need to implement a common table expression (CTE). Which code segment should you use?None of the aboveCREATE VIEW SalesByYearASSELECT Year,Region,SUM(OrderTotal)FROM OrdersGROUP BY Year, Region;GOSELECT Year, Region, Total FROM SalesByYear;;WITH SalesByYear (Year,Region,Total)AS(SELECT Year,Region,SUM(OrderTotal)FROM OrdersGROUP BY Year,Region)SELECT Year,Region,Total FROM SalesByYear;SELECT Year,Region,TotalFROM(SELECT Year,Region,SUM(OrderTotal) AS TotalFROM OrdersGROUP BY Year, Region) AS [SalesByYear];

Question 2Which of the following SQL statements will create a view that lists the job name and minimum and maximum salaries for jobs with a pay range of 50000 to 100000?1 pointCREATE VIEWAS SELECT JOB_TITLE, MIN_SALARY, MAX_SALARY FROM JOBSWHERE MIN_SALARY > 50000 AND MAX_SALARY < 100000;CREATE VIEW JobSalaryRanges(Job, StartingSalary, MaximumSalary)AS SELECT JOB_TITLE, MIN_SALARY, MAX_SALARY FROM JOBSWHERE SALARY > 50000 AND SALARY < 100000;CREATE VIEW JobSalaryRanges(Job, StartingSalary, MaximumSalary)AS SELECT JOB_TITLE, MIN_SALARY, MAX_SALARY FROM JOBSWHERE MIN_SALARY > 50000 AND MAX_SALARY < 100000;CREATE VIEW JobSalaryRanges(Job, StartingSalary, MaximumSalary)FROM JOBSWHERE MIN_SALARY > 50000 AND MAX_SALARY < 100000;

The following view statements contain the name, job title and the annual salary of employees working in the department 20: (Choose the correct)Select one:a.create view DEPT20 isselect ENAME, JOB, SAL*12 ANNUAL SALARY from EMPwhere DEPTNO = 20;b.create view DEPT20 asselect ENAME, JOB, SAL*12 ANNUAL SALARY from EMPwhere DEPTNO <> 20;c.create view DEPT20 asselect ENAME, JOB, SAL*12 ANNUAL SALARY from EMPwhere DEPTNO = 20;

Which of the following views are updatable?Select one:a. Views that included aggregate functionsb. All of the abovec. Views created from single relationd. Views created from joining of two tables

Which one of the following refers to the total view of the database content?a.Physical viewb.External viewc.Internal viewd.Conceptual view