what is the difference between first normal form & second
normal form?
Answer Posted / gopi
1NF: Eliminate duplicative columns from the same table and
create sepearate table for related group of data into
2NF: Remove and create sepearate table for common set of
data form multiple rows and create foregin key relationship
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How to define a procedure inside another procedure?
How to load data through external tables?
what is the scenario where you take the database to NoArchivelog mode?
Explain self joins in oracle?
What are the differences between number and binary_float in oracle?
Can we store images in oracle database?
Explain what are the characteristics of data files?
How to set up autotrace for a user account?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is tns service name?
Explain parameter file in oracle.
Name the various constraints used in oracle?
How to work with data objects interactively?
Explain view?
How to call a stored function in oracle?