what is normalization?
what is denormalization?

Answer Posted / sandeep yadav

Normalization is the process of decomposition of complex
data in to simple way.
Denormalization is vice versa.

Is This Answer Correct ?    8 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle error or exception in sql?

530


Is it possible to replicate data from sql server to oracle? : sql server replication

543


What happens if ntwdblib.dll is missing on your machine?

638


Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

578


what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

560






In which files does sql server actually store data?

471


How do you size a resultset?

500


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

635


What is sql language?

549


what authentication modes does sql server support? : Sql server database administration

521


as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

537


How to declare a cursor with "declare ... Cursor" in ms sql server?

567


What is a coalesce function?

666


What is store procedure? How do they work?

581


What is the use of group by clause?

527