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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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 de-normalization and when do you do it?
 Question Submitted By :: Latha Sree
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is de-normalization and when do you do it?
Answer
# 1		 
As the name indicates, denormalization is the reverse 
process of normalization. It's the controlled introduction 
of redundancy in to the database design. It helps improve 
the query performance as the number of joins could be 
reduced.
 
Is This Answer Correct ?    0 Yes 0 No
Swapna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the purpose of UPDATE STATISTICS?  1
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table? Leo-Technologies9
Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?  1
write the query for find the top 2 highest salary in sql server TCS17
How can your resolve deadlocks? IBM3
What is The Use Of TIMESTAMP DataType in SQL Server 2005?  2
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  1
What is the difference between HAVING clause and the WHERE clause?  4
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,... ADP1
What is the difference between windows authentication and sql server authentication HCL3
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?  2
What are cursors?  7
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?  3
Which stored procedure will you be running to add a linked server?  1
Which is best Subquery (or) joins in sql server? explain why  1
How to delete an attribute from the emp table  3
what is Constraint? How many types of constraints in SQL ? NIIT4
What is mean by "fill factor" ? and what is mean by "Index "in sql? Logica-CMG1
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?  3
can you any body tell me the how to decrease the logfile  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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