RDBMS Interview Questions

RDBMS Interview Questions
Download RDBMS Interview Questions PDF

Below are the list of Best RDBMS Interview Questions and Answers

In SQL, normalization of data is a process through with data is organized in tables used for the reduction of redundancy and dependency of data. It divides large tables into smaller ones using some set of rules.

Types of normalization:

  • 1NF: The rules of 1NF are that each table must contain a single value and records are required to be unique.
  • 2NF: The rules of 2NF are that the table must be in 1NF and must possess a single-column primary key.
  • 3NF: The rules of 3NF are that the table must be in 2NF and must not have any transitive functional dependencies.
  • BCNF: The rules of the Boyce Codd Normal form is that it must be in 3 NF and must not have more than one candidate key.

Following is a list of the differences between NoSQL and RDBMS: –

  • In terms of data format, NoSQL does not follow any order for its data format. Whereas, RDBMS is more organized and structured when it comes to the format of its data.
  • When it comes to scalability, NoSQL is more very good and more scalable. Whereas, RDBMS is average and less scalable than NoSQL.
  • For querying of data, NoSQL is limited in terms of querying because there is no join clause present in NoSQL. Whereas, querying can be used in RDBMS as it uses the structured query language.
  • The difference in the storage mechanism of NoSQL and RDBMS is that, NoSQL uses key value pair, documents, column storage, etc. for storage. Whereas, RDBMS uses various tables for storing data and relationships.