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 database normalization?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is database normalization?
Answer
# 1
It is the process of removing redundancy(repeated data) by
splitting the tables into smaller tables.
 
Is This Answer Correct ?    4 Yes 0 No
Koti-khammam
 
  Re: What is database normalization?
Answer
# 2
Normalize the data from the  detabase.It reduces by the 
normalisation rule like(there are 4 normalization rule and 
BCNF)
 
Is This Answer Correct ?    3 Yes 3 No
Maskfriend
 
 
 
  Re: What is database normalization?
Answer
# 3
Normalization is breaking the database into different 
tables and defining a relationship between them.
Objective is to isolate the data so that additions and 
deletions can be made in one table and propagated to other 
tables through relationships.
 
Is This Answer Correct ?    4 Yes 0 No
Anirudh
 
  Re: What is database normalization?
Answer
# 4
Normalization is the process of breaking  tables of a
database into smaller tables and defining relations between
them to make them more flexible, efficient and to remove the
modification anamolies from the database.
 
Is This Answer Correct ?    6 Yes 0 No
Shruti
 
  Re: What is database normalization?
Answer
# 5
Normalization is the process of structuring relational 
database schema such that most ambiguity is removed. The 
stages of normalization are referred to as normal forms and 
progress from the least restrictive (First Normal Form) 
through the most restrictive (Fifth Normal Form).
 
Is This Answer Correct ?    4 Yes 1 No
Kranthi
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?  1
How will u find the query which is running in some other machine IBM2
what is trigger NIIT1
What are the type of joins? When do we use Outer and Self joins?  3
Questions on identity? Infosys1
What types of integrity are enforced by a foreign-key constraint  1
What's the difference between a primary key and a unique key?  4
What are the different ways of moving data/databases between servers and databases in SQL Server? HCL2
What is the role that is required for killing a process What is the role that is required for creating a linked server IBM1
How do you find the number of rows in a table?  5
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all) McAfee4
What is the difference between views and stored procedures? Can we have input parameters for views?  3
What is blocking and how would you troubleshoot it?  1
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes.. Rolta5
Explain the architecture of SQL Server?  2
What is referential integrity? What are the advantages of it? Digital-Domain3
How m-m relationships are implemented?  1
How can you get @@error and @@rowcount at the same time?  5
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  5
Wht is Stuff in sql ser  1
 
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