Question 1Which of the following statements about views is correct?1 pointYou cannot change data in the base tables through a view.When you define a view, only the definition of the view is stored, not the data that it represents.A view can only represent data from a single table.A view is an independent copy of a single table’s structure, including the data.

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

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

Can a view be updated?Yes, but only if it's based on a single table.Yes, regardless of the number of tables it's based on.No, views are read-only.It depends on the database system.

What is TRUE about UPDATE in SQL VIEW?*Views that depend on a single table can be updated.An update of a view created from more than one table will not be allowed by SQL.There should be no NULL values in the fields of view.All of the above

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;