DBS Bank interview question

1. Explain the difference between a LEFT JOIN and a RIGHT JOIN. 2. Describe the differences between Pandas and PySpark. 3. Discuss methods for performing optimization.