Amazon Risk Specialist interview questions

1.What is the difference between DELETE, TRUNCATE, and DROP commands? 2.Explain the difference between PRIMARY KEY and UNIQUE KEY constraints? 3.What is the difference between HAVING and WHERE clause? 4. Explain the difference between UNION and UNION ALL 5. Find duplicate records in a table If student marks > 60 and attendance > 75%, then pass else the student fails.6.Difference between vlookup and hlookup

1. Tell me about a time when you handled conflict. How did you resolve it and what did you learn.