Sql questions

• Sql questions
• Sql tuning or sql optimisation
• Blob and text type
• Difference between have and where clause
• Difference among truncate,drop and delete commands
• Deleting duplicate entries in a table
• Normalisation and denormalisation