181
SQL Server Interview
Security, Backup, Recovery, Administration & Real-World Scenarios
SQL Server interview questions covering security, backup, recovery, administration & real-world scenarios.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
182
What authentication modes does SQL Server support?
183
What is the principle of least privilege?
184
What are server roles and database roles?
185
What is GRANT, DENY, and REVOKE?
186
What is SQL injection and how should it be prevented?
187
What is a full database backup?
188
What is a differential backup?
189
What is a transaction log backup?
190
What are SQL Server recovery models?
191
What is RPO and RTO?
192
How do you restore a SQL Server database?
193
How can you verify SQL Server backups?
194
What is DBCC CHECKDB?
195
What is SQL Server Agent?
196
What is Query Store?
197
What are Dynamic Management Views (DMVs)?
198
A production query suddenly becomes slow. What would you check first?
199
A database transaction log is growing rapidly. What should you investigate?
200