delete can be use with where clause . both can delete the complete data of table but truncate is faster . why truncate is faster? --> not answered normalization is used to restructure the existing tables structure to remove anomalies( deletion update insertion ) object can be anything which has properties (descriptions) and operation or behavior Class can be created by identifying the type of objects.