Question

Which one of the following is not true for a view:
* View is derived from other tables.
* View is a virtual table.
* A view definition is permanently stored as part of the database.
* View never contains derived columns.

Answer 1

Answer:

virual table shoul be the answer

Answer 2

'A view definition is permanently stored as part of the database' is not true among the given statements.

• In SQL, a view is a virtual table produced from the result set of a SQL action.
• In that it has rows and columns, a view is analogous to a table.
• Fields from one or more real tables in the database are used in views.
• The tuples in views are virtual tables, which means they don't exist physically and aren't saved in the database.
• The tuples are similar to temporary data that is formed as a result of a SQL query that normally pulls filtered data from one or more underlying tables.

#SPJ3