Dynamic view is not a temporary table and its definition is stored in the system catalog. The content of this view is materialized as a result of an SQL query that uses the view.

In SQL, Correlated subquery is a subquery that processes the inner query depending on the data from the outer query.

Materialized view is different from the dynamic view. It is stored on a disk and is refreshed when used or at some intervals. Copies of data is created in the same way as dynamic view.

Base Table is a table from relational data model that contains the inserted raw data. These tables are correspond to those relations which are identified in the conceptual schema of database.

Join is a relational operation that is used to combine two tables with a common domain into a single view or table.

Equi-join is a form of join in which the joining is performed on the basis of the equality between values in the columns that are common. Those common columns appear in the result table redundantly.

Sometimes a join requires match of rows in a table with other rows in that same table which means joining of table with itself. This is known as self join.

Outer join is a form of join in which those rows are not included in the resulting table that do not have similar values in the common columns.

Virtualized tables are not maintained as the tables with real data. These are constructed automatically as the requirement of a DBMS.