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

Why might you use a view in SQL?To hide complexity.To ensure data integrity.To improve query performance.All of the above.

What is a view?A view is a special stored procedure executed when certain event occurs.A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.A view is a database diagram.None of these

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

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;