Question

Which of the following is true about views?
a) A view can be created based on other views
b) Rows can be inserted and deleted from a view
c) All of the above
d) None of the above
Answer
A
B
С
D​

Answer 1

Answer:

(c) All of the above

Explanation:

It is true that a view can be created based on other views, and rows do can be inserted and deleted from a view.

Answer 2

Option c) All of the above is true

Explanation:

• A view is a virtual table in SQL that is created from the result set of a SQL operation.
• The CREATE VIEW statement is used to create a view. A view is similar to a table in that it has rows and columns. Fields from one or more real tables in the database are used in views. This allows creating views based on other views.
• We can include SQL statements and functions in a view to portraying data as though it came from a single table.