What are Joins, Views, Normalization, Triggers?
Joins: Join is a keyword used in SQL statements to operate two tables based on the relationship between given tables in the database.
Normalization: The process used for organizing data in an efficient way is known as normalization. There are several normal forms in which data is reduced for the minimization of errors. The goal of normalization is to eradicate redundant data and to make sure that data dependencies make sense.
Triggers: A trigger can be defined as an SQL procedure that is used to initiate any action in the database through SQL command.
BY Best Interview Question ON 22 Oct 2019