| 1 | What is SQL injection, and how does it relate to writing dynamic SQL unsafely? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Beginner |
| 2 | How do you safely use sp_executesql to execute dynamic SQL with parameters, avoiding the risks of simple string concatenation? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Intermediate |
| 3 | How would you build a dynamic SQL query where the table or column names themselves need to change based on input, since parameters cannot be used for object names? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Intermediate |
| 4 | What are the performance tradeoffs of using dynamic SQL compared to static, precompiled SQL statements? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Advanced |
| 5 | What is dynamic SQL, and why would you need to build and execute a SQL statement as a string rather than writing it directly? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Beginner |
| 6 | How do you debug a dynamic SQL statement when it fails or does not produce the expected results? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Intermediate |
| 7 | How would you build a dynamic SQL statement inside a stored procedure that constructs a flexible search query based on several optional filter parameters? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Advanced |
| 8 | What is dynamic data masking in SQL Server, and what problem does it solve? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | 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 is the difference between a SQL Server login and a database user? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Beginner |
| 11 | How do you declare and use a variable in T-SQL? SQL Server › T-SQL Fundamentals & Syntax | SQL Server | T-SQL Fundamentals & Syntax | Beginner |
| 12 | How do you grant a specific user or role permission to see the real, unmasked data despite dynamic data masking being applied? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 13 | Does dynamic data masking prevent a determined user from working around it to see the real underlying values? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 14 | How do you remove dynamic data masking from a column once it is no longer needed? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 15 | What is the principle of least privilege, and how should it guide how you grant permissions in SQL Server? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Intermediate |
| 16 | How would you apply dynamic data masking to an existing table with sensitive columns as part of a broader compliance initiative, such as meeting data privacy regulations? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Advanced |
| 17 | How does dynamic data masking behave differently when a masked column is used in a JOIN, WHERE clause, or exported through an application, compared to a simple SELECT query? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Advanced |
| 18 | How would you design a comprehensive security auditing strategy to track who accessed or modified sensitive data in a SQL Server database? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Advanced |
| 19 | What are the different cursor types available in SQL Server, such as static, dynamic, and forward only, and how do they differ? SQL Server › Cursors | SQL Server | Cursors | Intermediate |
| 20 | What is a stored procedure in SQL Server, and what are the main benefits of using one? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Beginner |
| 21 | What is Transparent Data Encryption in SQL Server, and what specifically does it protect? SQL Server › Transparent Data Encryption | SQL Server | Transparent Data Encryption | Beginner |
| 22 | What is the difference between what Transparent Data Encryption protects against compared to Dynamic Data Masking? SQL Server › Transparent Data Encryption | SQL Server | Transparent Data Encryption | Beginner |
| 23 | How does the syntax of the PIVOT operator work, and what are its main components? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Intermediate |
| 24 | How would you handle a pivoting scenario where the set of columns needed is not known ahead of time and could change over time? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Intermediate |
| 25 | What is the difference between using EXEC and calling a stored procedure through parameterized application code, and why does this distinction matter for security? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Intermediate |
| 26 | How do you use a view to help enforce a basic level of security by limiting which columns or rows different groups of users can see? SQL Server › Views | SQL Server | Views | Intermediate |