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 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 ?    2 Yes 2 No
Swapna
 
  Re: What is de-normalization and when do you do it?
Answer
# 2		 
If the database developer might want a reversal of 
normalization to improve performance is called 
denormalization.
 
Is This Answer Correct ?    0 Yes 0 No
Praveen
 
 
 
  Re: What is de-normalization and when do you do it?
Answer
# 3		 
Denormalization is a technique to move from higher to lower 
normal forms of database modeling in order to speed up 
database access.
 
Is This Answer Correct ?    0 Yes 0 No
Praveen
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju  3
What is lock escalation?  1
how to select 5 to 7 rows from a table, which contains 10 rows? IBM14
Write a query to delete duplicate records in SQL SERVER Infosys19
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output  5
What is the system function to get the current user's user id? TCS3
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback ) iGate2
write the query for taking database backup in sql Logica-CMG6
What is SQL Profiler what is the use of it? 247Customer2
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? Yardi-Software4
How to find the last update record in SQL Server?  3
how to get the automatic backup of the database in the sql server  3
what is the cursor life span? Evalueserve5
what is the difference between sql query and google query? TCS6
What is the difference between truncate and delete statement? CTS4
Which stored procedure will you be running to add a linked server?  1
What's the difference between a primary key and a unique key?  4
What are the types of backup and tell me the difference between full and differential backup? TCS3
What is a trigger?  3
WHAT IS UNIQUE IDENTIFIER DATA TYPE? Sparsh2
 
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