What are different normalization forms? ,Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher
What are different normalization forms?

 normalization have a se veral forms that a database structure can be subject to, each with rules that constrain the database further and each creating what is called a Normal Form. These are, in order:
> First Normal Form (1NF)
> Second Normal Form (2NF)
> Third Normal Form (3NF)
> Boyce Codd Normal Form (BCNF)
> Fourth Normal Form (4NF)
> Fifth Normal Form (5NF)
> Optimal Normal Form (ONF)
> Domain-Key Normal Form (DKNF)
Theses are defined as :
> 1NF: Eliminate Repeating Groups : Make a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain.
> 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. All attributes must be directly dependent on the primary key.
> 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.

More interview questions and answers

Explain. Two types of multi-tasking.

Explain Two ways to create the thread.

Explain Synchronization.

Explain I/O Filter.

Can applet in different page communicate with each other?

Why Java is not 100 % pure OOPS ? ( EcomServer )?

When we will use an Interface and Abstract class ?

How to communicate 2 threads each other ?

Describe difference between method overriding and overloading?

What is the restriction on an Overridden methods’ accessibility ?

What is the restriction on an Overridden methods’ accessibility ?

Can a method be overloaded by different return type but same argument type?

Can a method be overloaded by different return type but same argument type?

What is a "stateless" protocol?

What is constructor chaining and how to do this in Java?

What is constructor chaining and how to do this in Java?

What is passed by ref and by value?

What is passed by ref and by value?

How to ensure size of a primitive data type?

Elaborate the Garbage Collection process in Java ?

What is a difference between An interface and an abstract class?

In DB access where to write the query. In JSP or servlet?

In DB access where to write the query. In JSP or servlet?

Explain difference between Constructer and a method

Explain difference between Constructer and a method

What is serialization in Java?

Describe difference between an error and an exception?

What are differences between procedural and object oriented language?

What are differences between procedural and object oriented language?

What is the difference between a Class and an Object ?

What are the difference between DDL, DML and DCL commands?

Which one is faster DELETE/TRUNCATE?

Why threads block or enters to waiting state on I/O?

What is RDBMS?

What are different normalization forms?

What is normalization?

What are transient variables in java?

How Observer and Observable are used?

What is Stored Procedure

What is Trigger?

What is View?

What is Index?

What is List interface ?

What is SQL?

What is the difference between yield() and sleep()?

Can we call finalize() method ?

What is the initial state of a thread when it is created and started?

Can we declare an anonymous class as both extending a class and implementing an interface?

What are the components of physical database structure of Oracle database?

What are the components of logical database structure of Oracle database?

What is the differences between boolean & operator and && operator?

What is a tablespace?

What is SYSTEM tablespace and when is it created?

Explain the relationship among database, tablespace and data file.

What is an abstract method ?

What is schema?

What are Schema Objects?

what is a the difference between System.err and System.out

Can objects of the same schema reside in different table spaces?

Can a tablespace hold objects from different schemes?

What is Oracle table?

What is an Oracle view?

What is the difference between synchronized block and synchronized method ?

Do a view contain data?

How can you force garbage collection in java?

How can you call a constructor from another constructor ?

How can you call the constructor of super class ?

What must be the order of catch blocks when catching more than one exception?

How can we call a method or variable of the super class from child class ?

If you are overriding equals() method of a class, what other methods you might need to override ?

What is externalizable ?

Does garbage collection guarantee that a program will not run out of memory?

What is a native method?

What is the difference between a continue statement and a break statement?

What must a class do to implement an interface?

What is the difference between notifyand notifyAll method ?

What does wait method do ?

What are the different states of a thread ?

What is the difference between static and non static inner class ?

What is the difference between readers and streams?

Why we cannot override static methods?

When does a compiler supplies a default constructor for a class?

What will happen if an exception is not caught ?

What are the different ways in which a thread can enter into waiting state?

What is a ResourceBundle class?

What is numeric promotion?

What is the difference between the prefix and postfix forms of the ++ operator?

What is the difference between a switch statement and an if statement?

What is hashCode?

What is the difference between RandomAccessFile and File?

What is the difference among JVM Spec, JVM Implementation, JVM Runtime ?

What is the difference between Hashtable and HashMap ?

Why java is said to be pass-by-value ?

What do you mean by immutable ? How to create an immutable object ?

What is a weak reference ?

What is object cloning?

What is object pooling?

What is the disadvantage of garbage collection?

What are tag interfaces?

What are the restrictions placed on static method ?

R4R provides free online tutolrails ,examples for Freshers and experts .We cover core java, tutorials, spring, Hibernate, python, struts, struts 2,c language, spring boot,PHP,MYSQL,C#,ASP.NET,WPF,WCF,Photoshop , JSP, programming, example, Interview questions and answer