What is views? difference between table and view?

Question

Accepted Answer

Views are virtual tables that are based on the result of a query. They provide a way to simplify complex queries and restrict access to data.

Views are created by selecting columns from one or more tables and can include joins, filters, and calculations.
Unlike tables, views do not store data physically, but rather retrieve it dynamically from the underlying tables.
Views can be used to present a subset of data to users, hide sensitive information, or simplify complex queries.
Tables are used to store data permanently, while views are used to provide a virtual representation of the data.
Modifying data in a view can affect the underlying tables, but modifying data in a table does not affect the view.

Accepted Answer

Table is physically stored in database where as view is a virtual table and not physically exits

Accepted Answer

table is permenant it consumes some memory view is a one type of temporary table which was created during executing some queries views are for security purpose it does not consume any space in database

What is views? difference between table and view?

Top Kyzer Software Application Support Engineer interview questions & answers

Popular interview questions of Application Support Engineer