Tag Archives: 2016

MSSQL Concurrency Control and Locking – MSSQL Interview questions with answers

Posted on October 29, 2014 by uday arumilli

Concurrency Control And Locking SQL Server Concurrency Control Interview Questions Concurrency and Locking – Interview Questions with answers 1. What are the concurrent problems occur in accessing database? Ans: Tr – Transaction R – Resource Uncommitted dependency/dirty reads: Tr1 Updates Data R1 … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , | 1 Comment

MSSQL Security – Interview Questions and Answers

Posted on October 11, 2014 by uday arumilli

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