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   To Refer this Site to Your Friends   Click 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 normalization?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is normalization?
Answer
# 1
Well a relational database is basically composed of tables
that contain related data. So the Process of organizing this
data into tables is actually referred to as normalization.
 
Is This Answer Correct ?    0 Yes 0 No
Guest
 
  Re: What is normalization?
Answer
# 2
well normalization is a broader concept and couldbe called 
the back bone of RDBMS..
it involves multiple steps and levels ranginf grom 1-5
that removes dependencies repetition etc...
 
Is This Answer Correct ?    0 Yes 0 No
Ghous
 
 
 
  Re: What is normalization?
Answer
# 3
normalization is a design process for representing data in 
tabular format.the five normal forms are progressive rules 
to represent the data with minial redundancy
 
Is This Answer Correct ?    0 Yes 0 No
Suhail Qaiser
 
  Re: What is normalization?
Answer
# 4
Normalization is the process of removing redundant data and
preventing anomalies during database updates.

we have 1st degree, 2nd degree 3rd degree etc..

3rd degree normalization is commonly used.
 
Is This Answer Correct ?    0 Yes 0 No
Jerry Joseph
 
  Re: What is normalization?
Answer
# 5
It is the process of deciding which attributed has to 
grouped to avoid data redundancy.
 
Is This Answer Correct ?    1 Yes 0 No
Raj
 
  Re: What is normalization?
Answer
# 6
It is the process of desiging narrow tables from the 
collection of data to avoid repition of data
 
Is This Answer Correct ?    1 Yes 0 No
Jai
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records. 247Customer3
What are three SQL keywords used to change or set someone?s permissions?  3
Which TCP/IP port does SQL Server run on?  2
What is WITH CHECK OPTION Karur-Vysya-Bank-KVB2
What types of integrity are enforced by a foreign-key constraint  1
How to list all tables having unique constraints in any of the columns in a database.  1
Can anybody explain me cold backup and hot backup? TCS3
Which command using Query Analyzer will give you the version of SQL server and operating system?  3
What is a materialized view?  2
What is the difference between views and stored procedures? Can we have input parameters for views?  3
How many index keys possible for a table  6
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?  3
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?  2
How to find the date and time of last updated table? Teledata4
What is the difference between a local and a global variable?  3
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records  16
What is a view?  4
What is The Use Of TIMESTAMP DataType in SQL Server 2005?  3
Explain the storage models of OLAP?  1
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