When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.*JOINHAVINGGROUP BYAll of the above

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

Syntax for creating views is __________a.DROP VIEW AS SELECTb.CREATE VIEW AS SELECTc.CREATE VIEW AS UPDATE

Question : SQL Views are also known as

reate a view named "home_buildings" to select the name of the building_type whose electricity connection type is ‘Home’.Note:1. Do not change the name of the view2. Include only the name column present in the building_type table. Select only the building_type with the electricity connection type name as ‘Home’.3. Use subquery. Tables involved are building_type and electricity_connection_type4. Submit only the CREATE VIEW query.Instructions:1. Create the view successfully2. Once the view is created, check the correctness of the virtual table by displaying all the records in it.3. DO NOT submit the select query. Submit only the CREATE VIEW query.Sample Output:Created view will contain the following same data:Submit

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