ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
what is normalization?
what is denormalization?
 Question Submitted By :: Sam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is normalization? what is denormalization?
Answer
# 1
Normalization is a process of removing redundancy from the
tables.

De-normalization is  introducing redundancy.
 
Is This Answer Correct ?    7 Yes 0 No
Chethan Sy
 
  Re: what is normalization? what is denormalization?
Answer
# 2
Normalization is the process of organizing data in a 
database. This includes creating tables and establishing 
relationships between those tables according to rules 
designed both to protect the data and to make the database 
more flexible by eliminating two factors: redundancy and 
inconsistent dependency.
 
Is This Answer Correct ?    7 Yes 0 No
Shantanub
 
 
 
  Re: what is normalization? what is denormalization?
Answer
# 3
Normalization - is the process of desing of the datamodel 
and effocential storre the data in database
 
Is This Answer Correct ?    2 Yes 0 No
Hari
 
  Re: what is normalization? what is denormalization?
Answer
# 4
Normalization is the process of decomposition of complex 
data in to simple way.
Denormalization is vice versa.
 
Is This Answer Correct ?    0 Yes 3 No
Sandeep Yadav
 
  Re: what is normalization? what is denormalization?
Answer
# 5
In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. The objective is to
isolate data so that additions, deletions, and modifications
of a field can be made in just one table and then propagated
through the rest of the database via the defined relationships. 

De-normalization is  introducing redundancy.
 
Is This Answer Correct ?    1 Yes 1 No
Koti
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
WHAT IS UNIQUE IDENTIFIER DATA TYPE? Sparsh2
SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES Microsoft1
What is the basic functions for master, msdb, tempdb databases? CSC2
How to find the last update record in SQL Server?  3
Which virtual table does a trigger use?  3
How do we get month name in SQL Server 2000, Oracle, MS Access?  9
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
Define candidate key, alternate key, composite key.  9
What are tasks? Wipro1
What is a function? Give some example?  2
How do you check the performance of a query and how do you optimize it?  1
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))????? SAP-Labs2
What is Schema? and why we use schemas?  1
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??  8
can foreign key take role of primary key? TCS4
how many types of store procedre in sqlserver 2000? ATI2
How m-m relationships are implemented?  1
CLR Integration ? what is Notification services ? Satyam1
how can i view structure of table in sql server? tell me that query.  4
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL? HCL3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com