What is RDBMS and Types of Joins is SQL

Question

Accepted Answer

RDBMS stands for Relational Database Management System. Types of joins in SQL include INNER, LEFT, RIGHT, and FULL joins.

RDBMS is a type of database management system that stores data in a structured format using tables with rows and columns.
Types of joins in SQL include INNER JOIN (returns rows when there is a match in both tables), LEFT JOIN (returns all rows from the left table and the matched rows from the right table), RIGHT JOIN (returns all rows from the right table and the matched rows from the left table), and FULL JOIN (returns rows when there is a match in one of the tables).
Joins are used to combine rows from two or more tables based on a related column between them.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Popular interview questions of Technology Trainee