Here you will find more than 50000 job interview questions

Job Questions Search Engine


Sponsored Links

What is First Normal Form (1NF)

August 7, 2010 by bigboss · Leave a Comment
Filed under: Oracle Interview Questions, Relational Database Interview Questions 

First normal form (1NF)  is the first basic steps for normalization  for relational  database:

  • Eliminate duplicative columns from the same table t0 avoid redundancy .
  • There should be separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key).

Tags: ,

What is Normalization ?

August 7, 2010 by bigboss · Leave a Comment
Filed under: Oracle Interview Questions, Relational Database Interview Questions 

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.

Tags: ,

  • Categories

    |

  • Tags

    ADO.NET Questions Algorithm Questions ASP.NET Questions auto_ptr Binary tree questions C++ Constructor Interview Questions C++ Questions CISCO Exams Questions Common Interview Questions Core Java Interview Questions Csharp Questions datastructure questions Delphi 6 find command gdb interview questions grep interview questions IBM certification exams questions Infosys Puzzles Java Struts Linked List Problem Linux Command Questions List Manager Interview Questions Markov Algorithm memory leakage mysql Interview Questions Normalization Oracle Application Developer Certification Exam Interview Questions Oracle Questions Perl Questions PHP Questions Pointers Interview Questions PostgreSQL Database Questions pthread interview questions Smart Pointer Solaris Interview Questions SQL SERVER Interview Questions STL STL Map Symbian OS Tricky Interview Questions Unix Interview Questions unix shell Vector Windows OS Questions