Spectrum interview question

Few questions about SQL and how to handle large data