What is database ? What is joins and its types?

Question

Accepted Answer

A database is a collection of data that is organized in a way that allows for efficient retrieval and manipulation.

Joins are used to combine data from two or more tables based on a related column between them.
Types of joins include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables, left join returns all rows from the left table and matching rows from the right table, right join returns all rows from the right table and matching rows from the left table, and full outer join returns all rows from both tables.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Popular interview questions of Software Engineer