1.
What is the difference between INNER JOIN, LEFT JOIN, and FULL OUTER JOIN? Which JOIN returns only the matching records from both tables?
2.
What are the ACID properties of a database transaction? Which of the following is NOT an ACID property?
3.
What is the difference between a clustered and a non-clustered index? Which statement about a clustered index is correct?
4.
What is a stored procedure? What is a major advantage of using a stored procedure?
5.
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?
6.
Explain normalisation. What problem does 3NF solve? The primary purpose of Third Normal Form (3NF) is to eliminate:
7.
What is a view? What is a database view?
8.
What is the difference between WHERE and HAVING? Which clause is used to filter aggregated data after the GROUP BY operation?
9.
What is a transaction? Which SQL command permanently saves all changes made during a transaction?
10.
What is an identity column? How does an identity column differ from a sequence?
1 out of 1
