GM Technology SQL Developer interview questions

What is SQL? - Assessing understanding of SQL's purpose and capabilities. Explain the difference between DELETE and TRUNCATE commands. - Testing knowledge of data manipulation and consequences of using each. What are joins in SQL? Can you explain the different types? - Evaluating understanding of how to combine rows from two or more tables. How do you optimize SQL queries? - Gauging ability to write efficient queries and knowledge of performance factors.