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 of the following is/are true about views?Question 4Select one or more:a.It can be a result of multiple joins.b.Can be used interchangeably with tables when retrieving datac.Created to limit access to sensitive datad.Views do not contain real data

Question : SQL Views are also known as

SQL Views are also known as (ELITMUS)Options: Pick one correct answer from belowSimple tablesVirtual tablesComplex tablesActual Tables

Which of the following SQL statements will create a view named EMP_VIEW with an employee’s First name, last name, and ID, based on the EMPLOYEES tables?1 pointCREATE VIEW EMP_VIEW (EMP_ID, FIRSTNAME, LASTNAME)AS SELECT EMP_ID, F_NAME, L_NAMEFROM EMPLOYEES; CREATE VIEW EMP_VIEW (EMP_ID, FIRSTNAME, LASTNAME)FROM EMPLOYEES; CREATE VIEW EMP_VIEW (EMP_ID, FIRSTNAME, LASTNAME)AS SELECT EMP_ID, F_NAME, L_NAME;NEW VIEW EMP_VIEW (EMP_ID, FIRSTNAME, LASTNAME)AS SELECT EMP_ID, F_NAME, L_NAMEFROM EMPLOYEES;

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;