| 1 | 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 |
| 2 | How do you design a schema to properly handle a many to many relationship between two entities, such as students and courses? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Advanced |
| 3 | How do you choose an appropriately sized data type for a column to balance storage efficiency with future flexibility? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Intermediate |
| 4 | What factors should guide the decision to denormalize a schema for performance reasons, and what tradeoffs come with that decision? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Advanced |
| 5 | What is the difference between VARCHAR and NVARCHAR, and when should you choose one over the other? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Beginner |
| 6 | What are the differences between DATETIME, DATETIME2, and DATE, and when would you choose each one? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Intermediate |
| 7 | How do computed columns work in SQL Server, and what are some practical use cases for them? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Intermediate |
| 8 | What is database normalization, and why is it an important concept in schema design? SQL Server › Normalization | SQL Server | Normalization | Beginner |
| 9 | What built-in masking functions are available in SQL Server for dynamic data masking? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Beginner |
| 10 | What does it mean to pivot data in SQL Server, and what kind of reporting need does it typically address? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Beginner |