Creative IT India Support Engineer Interview Questions and Answers

Right join and left join are types of joins used in SQL to combine rows from two or more tables based on a related column between them.

• Left join returns all rows from the left table and the matched rows from the right table, with null values where there is no match.

• Right join returns all rows from the right table and the matched rows from the left table, with null values where there is no match.

• Example: SELECT * FROM t...read more

An index is a data structure that improves the speed of data retrieval operations in a database.

• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Indexes can be created on one or multiple columns in a table.

• Examples of indexes are primary keys, foreign keys, and indexes created for frequently searched columns.