Tag Archives: SQL Server interview questions with answers

MSSQL Security – Interview Questions and Answers

sql server security interview questions   1. What is the Guest user account in SQL Server?  What login is it mapped to it?   Ans: The Guest user account is created by default in all databases and is used when explicit … Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , | 5 Comments

SQL Server Backup and Restore Interview Questions

SQL Server Backup and Restore Interview Questions   Here are the list of SQL Server Backup and Restore Interview Questions which are asked in SQL Server DBA interviews. 1. How does the database recovery model impact database backups? Ans: First the … Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , | 14 Comments

SQL Server Architecture Questions and Answers

SQL Server Architecture Questions and Answers   Here are the list of Sql Server Architecture Questions and Answers which are asked in SQL Server developer / DBA  interviews Q. Can you draw SQL Server architectural diagram with all the components? … Continue reading

Posted in Database Design, Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | 60 Comments