What is Normalisation ? - oracle

What is Normalisation ?

Normalisation is the process of organising the tables to remove the redundancy.There are mainly 5 Normalisation rules.
a) 1 Normal Form :: A table is said to be in 1st Normal Form when the attributes are atomic
b) 2 Normal Form :: A table is said to be in 2nd Normal Form when all the candidate keys are dependant on the primary key
c) 3rd Normal Form :: A table is said to be third Normal form when it is not dependant transitively

What is the Difference between a post query and a pre query 
A post query will fire for every row that is fetched but the pre query will fire only once.

Deleting the Duplicate rows in the table 
We can delete the duplicate rows in the table by using the Rowid

Can U disable database trigger? How? 
Yes. With respect to table
ALTER TABLE TABLE
[[ DISABLE all_trigger ]]