SQL Database Concepts Question: Download Questions PDF
Do you know what is Normalization of database? What are its benefits?
Answer:
-Normalization is set of rules that are to be applied while designing the database tables which are to be connected with each other by relationships. This set of rules is called Normalization.
-Benefits of normalizing the database are
1. No need to restructure existing tables for new data.
2. Reducing repetitive entries.
3. Reducing required storage space
4. Increased speed and flexibility of queries.
-Benefits of normalizing the database are
1. No need to restructure existing tables for new data.
2. Reducing repetitive entries.
3. Reducing required storage space
4. Increased speed and flexibility of queries.
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell me the phases a transaction has to undergo? | Explain what is the purpose of SQL Profiler in SQL server? |