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   SiteMap shows list of All Categories in this site.
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 and its forms?
 Question Submitted By :: Honeysukumar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is normalization and its forms?
Answer
# 1
Normalization is process of reducing redundancy of a 
database , by decomposing the database into several smaller 
files ( tables) and using the concept of codification

Forms 1NF,2NF,#NF , boyce codd NF
 
Is This Answer Correct ?    7 Yes 2 No
Sd
 
  Re: What is normalization and its forms?
Answer
# 2
Normalization is the process of splitting the table into 
multiple subtables based on their functional dependency.

Forms are First normal form, Second normal form, and Third 
normal form.
 
Is This Answer Correct ?    4 Yes 1 No
Srinivas
 
 
 
  Re: What is normalization and its forms?
Answer
# 3
Database normalization, sometimes referred to as canonical
synthesis, is a technique for designing relational database
tables to minimize duplication of information and, in so
doing, to safeguard the database against certain types of
logical or structural problems, namely data anomalies. For
example, when multiple instances of a given piece of
information occur in a table, the possibility exists that
these instances will not be kept consistent when the data
within the table is updated, leading to a loss of data
integrity. A table that is sufficiently normalized is less
vulnerable to problems of this kind, because its structure
reflects the basic assumptions for when multiple instances
of the same information should be represented by a single
instance only.

Higher degrees of normalization typically involve more
tables and create the need for a larger number of joins,
which can reduce performance. Accordingly, more highly
normalized tables are typically used in database
applications involving many isolated transactions (e.g. an
automated teller machine), while less normalized tables tend
to be used in database applications that need to map complex
relationships between data entities and data attributes
(e.g. a reporting application, or a full-text search
application).

Database theory describes a table's degree of normalization
in terms of normal forms of successively higher degrees of
strictness. A table in third normal form (3NF), for example,
is consequently in second normal form (2NF) as well; but the
reverse is not necessarily the case.

Although the normal forms are often defined informally in
terms of the characteristics of tables, rigorous definitions
of the normal forms are concerned with the characteristics
of mathematical constructs known as relations. Whenever
information is represented relationally, it is meaningful to
consider the extent to which the representation is normalized.
 
Is This Answer Correct ?    3 Yes 2 No
Rohit
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What types of integrity are enforced by a foreign-key constraint  1
What is bit datatype and what's the information that can be stored inside a bit column?  1
What is the difference between local table and global table Polaris1
What is Schema? and why we use schemas?  1
The Difference between 'Count' and 'Count(*)'  12
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables? TCS3
What is a deadlock and what is a live lock? How will you go about resolving deadlocks? Microsoft1
When you first load SQL SERVER you will startup with what all databases? CompuSol3
What do u mean by orphan users, how will u list them in the DB IBM2
What is the difference between constraints and triggers? Wipro6
What is the difference between a stored procedure and a user defined function in sql server? Millennium2
wat is the main diff between sql server 2000and sql server 2005 Jade-Software6
SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES Microsoft1
What are the steps you will take to improve performance of a poor performing query? HCL1
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  2
WHAT OPERATOR PERFORMS PATTERN MATCHING? CTS2
how to give input dynamically to a insert statement in sqlserver HCL2
i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution? Aptech4
Which data type can be used only on OUTPUT parameters of the stored proceduer?  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 interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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