Pergunta de entrevista da empresa Agoda

1.what is Temp table and temp variable? 2. Stored Procedures ? 3. What are the nested loop joins 4. Merge joins and Hash joins 5 what are indexes , Cluster index and non-cluster index 6. you must work on performance tuning expert in postgrad SQL ? 7. query optimization? 8. what is statistics?