what is temporary table and what is view

Question

Accepted Answer

Temporary table is a table that exists temporarily and is used to store data temporarily. A view is a virtual table that is based on the result-set of an SQL statement.

Temporary table is created for a specific session or task and is dropped automatically when the session is closed or the task is completed.
Temporary table can be used to store intermediate results during complex queries or to store data that needs to be manipulated before being inserted into a permanent table.
View is a read-only virtual table that is created by joining one or more tables or by selecting a subset of columns from a table.
View can be used to simplify complex queries, to restrict access to sensitive data, or to provide a customized view of data for different users.
Temporary table and view can be used together to create complex queries that require intermediate results and customized views of data.

what is temporary table and what is view

Popular interview questions of Database Developer

Top HR questions asked in First American Corporation Database Developer