SQL Interview Questions and Answers Archives - Page 38 of 67

Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects

January 17, 2016

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Sometimes questions in the interview are extremely open ended and such questions can be very useful for candidate to play around with. For example, in one of the recent interview one of the interviewer asked the candidate that what is his favorite T-SQL script as a database administrator. The answer…

Interview Question of the Week #053 – What is the Difference Between Deterministic Functions and Nondeterministic Functions?

January 10, 2016

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Function

Some questions are so theoretical that I believe they really do not add too much value if users know that question or not. Here is one such question I am very confident that you agree with my point of view. Questions: What is the Difference Between Deterministic Functions and Nondeterministic Functions?…

Interview Question of the Week #052 – Print String in Reverse Order

January 3, 2016

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Last week, I attended the last interview of the year. One of my co-interviewer asked a coding question to the candidate. In this type of question, the candidate is given one hour with SQL Server with a help file. The computer does not have internet candidate can use all the…

Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan

December 27, 2015

Pinal Dave

SQL Interview Questions and Answers

Execution Plan, SQL Server, SQL Server Management Studio

In one of the recent interview, I met quite a few interesting candidates. It is common for employees ask many questions during an interview, but there are times when candidates also ask questions back to the interviewee. I was asked following question recently.

Question: Do you use Actual Execution plan or Estimated Execution plan?

Interview Question of the Week #050 – Query to Retrieve Second Highest Salary of Employee

December 20, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

There are some questions which never gets old and I keep on seeing them again and again every time I participate in the interview to help hire qualified Developers and DBA. Here is another popular question which I often see. Question: Write a query to retrieve Second (or Nth) highest…

Interview Question of the Week #049 – Taking Database Offline

December 13, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Scripts

Here is the conversation which I observed the other day. Question: How do we take database off-line? Answer: Well, we can run following script to take the database offline. ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE Question: Let us assume that your boss suggest that you should wait 30…

Interview Question of the Week #048 – How to Move TempDB to Another Drive?

December 6, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL TempDB

In a recent interview when the interviewer asked interview that TempDB can be moved to a different drive, the candidate was extremely surprised. For the benefits of the interviewee who did not know the answer, I have written this blog post. Question: How to move TempDB to another drive? Answer:…