SQL Server Interview Questions - Calsoft

1. Write a SQL query to join multiple tables?
2. Write a SQL query to optimize the data that is received after joining the tables?
3. How to disable an index using select query?
4. Which one is faster clustered index or non-clustered index?
5. What are the types of optimization used in queries?
6. What is the difference between ISQL and OSQL?