Author Archives: uday arumilli

SQL DBA – INTERVIEW QUESTIONS ANSWERS – 2

Posted on November 13, 2014 by uday arumilli

SQL DBA – INTERVIEW QUESTIONS ANSWERS – 2 SQL Server Database Administrator – Interview Questions This post “SQL DBA – INTERVIEW QUESTIONS ANSWERS – 2”  helps SQL DBA for interview preparation. Q. Does TRUNCATE is a DDL or DML and … Continue reading →

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

SQL DBA INTERVIEW QUESTIONS WITH ANSWERS – 1

Posted on November 7, 2014 by uday arumilli

SQL DBA Interview Questions with Answers – 1 SQL DBA Interview Questions with Answers Q. What are the common issues a SQL DBA should deal with as a part of DBA daily job? Ans: Backup Failure Restore Failure Log Full Issues … Continue reading →

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

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