1. Types of join in SQL and describe all with example . 2. Types of constraints in SQL and elaborate all. 3. What is view and types of view. 4. What is index in SQL.

Question

Accepted Answer

Types of joins, constraints, views, and indexes in SQL.

Types of joins in SQL: Inner Join, Left Join, Right Join, Full Join, Cross Join.
Types of constraints in SQL: Primary Key, Foreign Key, Unique, Not Null, Check.
Views in SQL are virtual tables that display data from one or more tables. Types include Simple Views, Complex Views, Materialized Views.
Indexes in SQL are used to quickly retrieve data from a table. Types include Clustered Index, Non-Clustered Index, Unique Index, Composite Index.

1. Types of join in SQL and describe all with example . 2. Types of constraints in SQL and elaborate all. 3. What is view and types of view. 4. What is index in SQL.

Popular interview questions of SQL and PL SQL Developer