Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization?
what is denormalization?
- 9 Answers
- 35086 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / abdul quadir parihar
Normalization is the process of decomposition of complex
data in to simple way.
Denormalization is basically applied in the case the
database is over-normalised and no. of joins required to
fetch the data are too much. It is a purposeful redundancy
of some of the data to avoid the overhead of joins.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Tell me what are cursors and when they are useful?
Can you use order by when defining a view?
What are the differences between clustered and non-clustered index?
What is the use of commit?
How to convert binary strings into integers in ms sql server?
What is cursors? And what are the different types of cursor?
Can sql servers linked to other servers?
please differentiate between delete and truncate?
What is dirty read?
How to loop through the result set with @@fetch_status?
What is blocking and how would you troubleshoot it? : sql server database administration
Define normalisation?
What are the different SQL Server Versions you have worked on?
Mention the different types of replication in sql server.
Write a sql query to delete duplicate records from a table called table1
