What is the difference between INNER JOIN, LEFT JOIN, and FULL OUTER JOIN? Which JOIN returns only the matching records from both tables?
What are the ACID properties of a database transaction? Which of the following is NOT an ACID property?
What is the difference between a clustered and a non-clustered index? Which statement about a clustered index is correct?
What is a stored procedure? What is a major advantage of using a stored procedure?
What is the difference between DELETE, TRUNCATE, and DROP? Which command removes all rows from a table while keeping its structure intact and is generally faster than DELETE?
Explain normalisation. What problem does 3NF solve? The primary purpose of Third Normal Form (3NF) is to eliminate:
What is a view? What is a database view?
What is the difference between WHERE and HAVING? Which clause is used to filter aggregated data after the GROUP BY operation?
What is a transaction? Which SQL command permanently saves all changes made during a transaction?
What is an identity column? How does an identity column differ from a sequence?
