Explain database Normalization?
Submitted by: AdministratorIt is the process of organizing data into related table.
To normalize database, we divide database into tables and establish relationships between the tables.
It reduces redundancy. It is done to improve performance of query.
Submitted by: Administrator
To normalize database, we divide database into tables and establish relationships between the tables.
It reduces redundancy. It is done to improve performance of query.
Submitted by: Administrator
Read Online SQL Server Functions Job Interview Questions And Answers
Top SQL Server Functions Questions
☺ | Explain Steps of normalization? |
☺ | What is De-normalization? |
☺ | Explain how DTS is used to extract, transform and consolidate data? |
☺ | Do you know exporting and importing utility? |
☺ | What are scalar functions? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |