what is the difference between first normal form & second
normal form?

Answer Posted / prabhu

to reduce the retundant column for that only we r using the
first normal form




create seperate table for not functionality dependent
on primary key this is 2nd normal form

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the set operators union, union all, minus & intersect meant to do?

560


What is a select query statement in oracle?

543


When do you get a .pll extension in oracle? Explain its importance

572


What is index in Oracle?

584


How to get execution statistics reports on query statements?

567






Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1502


How to shutdown your 10g xe server from command line?

554


How to get a list of all background sessions in the database?

535


What do you mean by merge in oracle and how can we merge two tables?

575


what are the default admin accounts in Oracle 10g ?

503


How to add a new column to an existing table in oracle?

584


Explain the use of rows option in imp command.

604


What are the restrictions on external table columns?

545


Explain compound trigger in oracle?

546


What is an oracle cursor variable?

607