| 1 | What is a foreign key constraint, and how does it help maintain data integrity between two related tables? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Beginner |
| 2 | How do cascading actions work with foreign key constraints, such as ON DELETE CASCADE, and what risks come with using them? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Advanced |
| 3 | What is a primary key constraint, and why is it important for a database table? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Beginner |
| 4 | How is a unique constraint different from a primary key constraint, and when would you use one instead of the other? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Intermediate |
| 5 | What is a check constraint, and how do you use one to enforce a specific business rule at the database level? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Intermediate |
| 6 | How do you temporarily disable a constraint to perform a bulk data load, and how do you safely re-enable it afterward? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Intermediate |
| 7 | How would you add a new constraint to an existing table that already contains data, especially if some existing rows might violate that constraint? SQL Server › Constraints (Primary Key, Foreign Key, Check & Unique) | SQL Server | Constraints (Primary Key, Foreign Key, Check & Unique) | Advanced |
| 8 | What are the most commonly used data types in SQL Server, and when would you use each one? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Beginner |
| 9 | What is the difference between a clustered index and a nonclustered index? SQL Server › Indexes | SQL Server | Indexes | Beginner |
| 10 | What is an INNER JOIN, and how does it combine data from two tables? SQL Server › Joins | SQL Server | Joins | Beginner |