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
wht is normalization?can u explain me in detail?
 Question Submitted By :: Karunakar Reddy
I also faced this Question!!     Rank Answer Posted By  
 
  Re: wht is normalization?can u explain me in detail?
Answer
# 1
Normalization is the process of efficiently organizing data 
in a database. There are two goals of the normalization 
process: eliminating redundant data and ensuring data 
dependencies make sense
 
Is This Answer Correct ?    7 Yes 1 No
Ramesh L.v.
 
  Re: wht is normalization?can u explain me in detail?
Answer
# 2
Normalisation is when you reduce redundancy of data in
tables & increase performance
 
Is This Answer Correct ?    3 Yes 3 No
Guest
 
 
 
  Re: wht is normalization?can u explain me in detail?
Answer
# 3
The process of separating data into distinct, unique sets 
is called normalization.
 
Is This Answer Correct ?    4 Yes 1 No
Nesa4180
 
  Re: wht is normalization?can u explain me in detail?
Answer
# 4
It is the process of removing redundancy data by splitting
the the tables into smaller tables in order to improve the
performance of the data retrieval.
 
Is This Answer Correct ?    1 Yes 1 No
Koti
 
  Re: wht is normalization?can u explain me in detail?
Answer
# 5
Normalization is the process of efficiently organizing data 
in a database. There are two goals of the normalization 
process: eliminating redundant data and ensuring data 
dependencies make sense
    0  Ramesh L.v. 
 
   
   Re: wht is normalization?can u explain me in detail? 
Answer
# 2 Normalisation is when you reduce redundancy of data in
tables & increase performance
    0  Guest 
 
  
 
 
  
   
   Re: wht is normalization?can u explain me in detail? 
Answer
# 3 The process of separating data into distinct, unique 
sets 
is called normalization.
    3  Nesa4180 
 
   
   Re: wht is normalization?can u explain me in detail? 
Answer
# 4 It is the process of removing redundancy data by 
splitting
the the tables into smaller tables in order to improve the
performance of the data retrieval.
 
Is This Answer Correct ?    1 Yes 1 No
Md.abdul Azeez
 
  Re: wht is normalization?can u explain me in detail?
Answer
# 6
Normalization is the process of designing the datamodel and 
effocientely store the data in database.to reduce the 
redundancy.
1Normal form: Elimanate the repeating groups for individual 
table
-Create sepeare table for each set of related data 
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values 
that apply the multipule records. 
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on 
the key
 
Is This Answer Correct ?    0 Yes 3 No
Hari
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
select empid empname from employee What is the result for the about query?  4
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 command using Query Analyzer will give you the version of SQL server and operating system?  3
what is web server? Satyam3
Can anybody explain me cold backup and hot backup? TCS3
What is blocking and how would you troubleshoot it? HCL2
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))????? SAP-Labs2
how to know Who Is Blocking Your SQL Server?  3
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query? Infosys3
What is the diff between Static Queries and Dynamic queries give me some examples CSC1
What is cursor ? And what is difference between Trigger ? HCL1
What are user defined datatypes and when you should go for them?  1
How do you measure the performance of a stored procedure? Infosys1
What is Covering Indexes? Plz explain with example  2
What is the use of DBCC commands?  1
What is a transaction and what are ACID properties?  2
what is the difference between sql query and google query? TCS7
Which virtual table does a trigger use? TCS6
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs. APX2
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