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                      
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 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 ?    2 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 ?    1 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 ?    0 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 0 No
Sandeep Yadav
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How do you use DBCC statements to monitor various aspects of a SQL server installation?  1
How can you see what type of locks used?  1
How to write query to Delete the records in child table and corresponding records in parent table Semantic-Space7
What is the diff between Dynamic queries and static queries ICS-Integrated-Computer-Solutions1
How to select Distinct columns from the table, table having 20 columns and i want all coulmns Wipro2
What is the appropriate number of test cases that you can write on a database? Microsoft1
wht is normalization?can u explain me in detail? TCS6
1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........  1
What is database replicaion? What are the different types of replication you can set up in SQL Server?  2
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS? GE1
How m-m relationships are implemented?  1
What are the steps you will take to improve performance of a poor performing query? HCL1
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?  1
What are cursors? Name four types of cursors and when each one would be applied? Adea-Solutions1
What are constraints? Explain different types of constraints?  5
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.  7
How do we get current date in SQL Server 2000, Oracle, MS Access?  10
How the data stores in a page?  1
What do you mean by COLLATION?  4
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM Wipro4
 
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