SQL Questions Write a SQL query to find the second highest salary from a table of employees. How would you optimize a slow-running query? Explain the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. Cloud Questions What are some common AWS services you’ve used, and how did you utilize them in your projects? Explain the differences between AWS EC2 and AWS Lambda. How do you manage cloud resources to ensure cost efficiency? Coding Questions Write a Python function to reverse a linked list. How would you implement a stack using queues in Python? Solve a problem involving algorithmic complexity, like finding the nth Fibonacci number. Pandas Questions How would you handle missing data in a DataFrame using Pandas? Explain how to merge two DataFrames on a common key. Describe how you would perform data aggregation and summarization with Pandas. Python Questions About Projects and Internships Describe a challenging problem you solved during your internship and the approach you took. How did you use Python in your sentiment analysis project? Explain a particular function or library you frequently used in your projects and why.
