SQL Server Interview Questions - CDOT

1. Write a SQL Query to get all the records from different tables?
2. Write a query to join two tables and get all the records out of it?
3. What are the different types of optimizations used?
4. What is the difference between inline query and stored procedure?
5. What are different types of query that exists in Database?