Category Archives: Interview Q&A

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

Interview Questions

sql server experienced interview questions Hello All, I have been collecting interview questions from the people who given interviews at various organizations. Below are the list of questions. It includes, SQL DBA, MSBI, SQL Developer, SQL Server. 1 ​ Organization … Continue reading

Posted in High Availability, Interview Q&A, MSBI, Performance Tuning, SQL Development, SQL Server DBA, SSIS, SSRS | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 68 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