Why we use normalisation in database? Types of joins. Difference between DBMS and RDBMS. What is trigger?

Question

Accepted Answer

Normalization is used in databases to reduce data redundancy and improve data integrity.

Normalization helps in organizing data in a database by eliminating redundant data and ensuring data integrity.
It reduces data redundancy by breaking down large tables into smaller ones and linking them using relationships.
Types of joins include inner join, outer join, left join, and right join.
DBMS stands for Database Management System, while RDBMS stands for Relational Database Management System.
DBMS is a software that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.
A trigger is a set of instructions that automatically execute when a certain event occurs in a database.
For example, a trigger can be used to update a table when a new record is inserted or to enforce data integrity rules.

Top Coforge Test Engineer interview questions & answers