ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> Databases >> SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions (2035)
 SQL Server interview questions  SQL Server Interview Questions (1075)
 MS Access interview questions  MS Access Interview Questions (24)
 MySQL interview questions  MySQL Interview Questions (194)
 Postgre interview questions  Postgre Interview Questions (6)
 Sybase interview questions  Sybase Interview Questions (22)
 DB Architecture interview questions  DB Architecture Interview Questions (5)
 DB Administration interview questions  DB Administration Interview Questions (213)
 DB Development interview questions  DB Development Interview Questions (53)
 SQL PLSQL interview questions  SQL PLSQL Interview Questions (768)
 Databases AllOther interview questions  Databases AllOther Interview Questions (106)
Question
What is normalization and types of normalization?
 Question Submitted By :: Geethu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is normalization and types of normalization?
Answer
# 1
Normalization is process for reducing the redency of the
data.there 5 normal forms mainly used in 3 forms
4th one boyesscoded normal form
 
Is This Answer Correct ?    234 Yes 51 No
Rao
 
  Re: What is normalization and types of normalization?
Answer
# 2
Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data (for example, storing
the same data in more than one table) and ensuring data
dependencies make sense (only storing related data in a
table). Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure that data is
logically stored.
 
Is This Answer Correct ?    178 Yes 37 No
Aa
 
 
 
  Re: What is normalization and types of normalization?
Answer
# 3
Database normalization 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.
1NF Eliminate Repeating Groups - Make a separate table for
each set of related attributes, and give each table a
primary key.
2NF Eliminate Redundant Data - If an attribute depends on
only part of a multi-valued key, remove it to a separate table.
3NF Eliminate Columns Not Dependent On Key - If attributes
do not contribute to a description of the key, remove them
to a separate table.
BCNF Boyce-Codd Normal Form - If there are non-trivial
dependencies between candidate key attributes, separate them
out into distinct tables.
4NF Isolate Independent Multiple Relationships - No table
may contain two or more 1:n or n:m relationships that are
not directly related.
5NF Isolate Semantically Related Multiple Relationships -
There may be practical constrains on information that
justify separating logically related many-to-many relationships.
ONF Optimal Normal Form - a model limited to only simple
(elemental) facts, as expressed in Object Role Model notation.
DKNF Domain-Key Normal Form - a model free from all
modification anomalies.
 
Is This Answer Correct ?    147 Yes 24 No
J Geor
 
  Re: What is normalization and types of normalization?
Answer
# 4
It is set of rules that have been established to aid in the
design of tables that are meant to
be connected through relationships. This set of rules is
known as Normalization

First Normal Form

Second Normal form

Third normal form
 
Is This Answer Correct ?    52 Yes 42 No
Sri
 
  Re: What is normalization and types of normalization?
Answer
# 5
it is a process of effectively arranging data in database .
types
first normal form
second normal form
third normal form
boyce code normal form
 
Is This Answer Correct ?    48 Yes 32 No
Sakthivel
 
  Re: What is normalization and types of normalization?
Answer
# 6
Normal forms in SQL are given below.

First Normal form (1NF): A relation is said to be in 1NF if
it has only single valued attributes, neither repeating nor
arrays are permitted.

Second Normal Form (2NF): A relation is said to be in 2NF if
it is in 1NF and every non key attribute is fully functional
dependent on the primary
key.

Third Normal Form (3NF): We say that a relation is in 3NF if
it is in 2NF and has no transitive dependencies.

Boyce-Codd Normal Form (BCNF): A relation is said to be in
BCNF if and only if every determinant in the relation is a
candidate key.

Fourth Normal Form (4NF): A relation is said to be in 4NF if
it is in BCNF and contains no multi valued attributes.

Fifth Normal Form (5NF): A relation is said to be in 5NF if
and only if every join dependency in relation is implied by
the candidate keys of relation.

Domain-Key Normal Form (DKNF): We say that a relation is in
DKNF if it is free of all modification anomalies. Insertion,
Deletion, and update anomalies come under modification
anomalies.
--- *********************---
 
Is This Answer Correct ?    95 Yes 17 No
Udhaya Kumar
 
  Re: What is normalization and types of normalization?
Answer
# 7
Normalization is a systematic way of ensuring that a
database structure is suitable for general purpose querying
and free of certain undesirable characteristics—insertion,
update, and deletion anomalies that could lead to a loss of
data integrity.
 
Is This Answer Correct ?    33 Yes 12 No
Danish Mahmood
 
  Re: What is normalization and types of normalization?
Answer
# 8
a systematic way of ensuring that a database structure is
suitable for general purpose querying & free of certain
undesirable characteristics insertion,update,& deletion
anomalies that could lead to a lose of data integrity
 
Is This Answer Correct ?    25 Yes 15 No
Tariku
 
  Re: What is normalization and types of normalization?
Answer
# 9
breaking of a table is called normalization.
types of normalization ar
1NF, 2NF, 3NF
 
Is This Answer Correct ?    36 Yes 22 No
Alina
 
  Re: What is normalization and types of normalization?
Answer
# 10
Normalization

This topic is a bit digressing from a DW point of view. But
it is better that we know about Normalization. Once we
understand Normalization & DW facts & dimensions, the schema
concepts would be clearer. It would help us understand why
reporting is easier & faster from a DW. There are 5 types of
Normalization. But for now it’s enough to understand 3 types
of Normalization. Normalization helps in reducing data
redundancy. As we move towards higher normalization

1NF: This type of normalization states that there must not
be any duplicates in the tables that we use. In other words,
all the tables used must have a primary key defined.

2NF: This type of normalization states that data redundancy
can be reduced if attributes those are dependent on one of
the keys of a composite primary key are isolated to a
separate table. Not only does this reduces data redundancy
but also helps in increasing data retention when a delete is
done. For example, consider a table that has the following
columns: Part Id, State, City, and Country. Here, assume
Part Id & Country form the composite primary key. The
attributes state & city depend only on the country. 2NF
states that if such is the case then split the table into 2
tables. One with Part Id & country as the columns. Other
with Country, state & city as the columns. In the 1st table
if a delete is made to all the rows with Part Id = ‘X’ then
we would lose country related data too. But in the 2nd case
this would not happen.

3NF: This type of normalization states that if a dependency
exists on certain attributes other than the primary key then
the table split depending on the dependency has to be done.
Consider the same example above. In the present case
consider that Part Id is the only primary key. Now state,
city depend only on country & not on Part Id. This table is
already in 1NF & 2NF. But to achieve 3NF we would do the
same split as above.
 
Is This Answer Correct ?    49 Yes 10 No
Prasad Kumar
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
what is global variable in pl/sql   1
What is difference between a PROCEDURE & FUNCTION ? Satyam 6
What is dynamic SQl and how you will create and execute dynamic sql? TCS 2
Difference between SUBSTR and INSTR?   3
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc   1
what is explain plan?, given an example... Polaris 3
What can be a size of a pl/sql block? Is there any limit?   2
What is the difference between anonymous block and named block or stored procedure?   7
What are the components of a PL/SQL block ?   1
What is Difference between StoredProcedure and function?   3
select 1,col1,col2 from table1. output? Ramco 5
Find out the 3rd highest salary? BirlaSoft 50
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright © 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com