SQL Interview Questions and Answers Archives - Page 44 of 67

Interview Question of the Week #012 – Steps to Restore Bak File to Database

March 22, 2015

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

Here is the question, I was asked the other day at the conference. Question: If I have a .bak file and I want to restore it database what are the various steps involved in it. Assume that I do not know much about that backup file. Answer: I love this question,…

Interview Question of the Week #011 – Script to Convert List to Table and Table to List

March 15, 2015

Pinal Dave

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

Now today’s interview question is really more of daily routine task for many of the developer. 11 years ago, when I went to my very first interview call. My interview was scheduled at 6 PM in one of the very well known corporation. The corporation was known for its first…

Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?

March 8, 2015

Pinal Dave

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

I often see people getting confused between Primary Key and Unique Key. I see where people get confused about the same. Let us discuss. Question: “What is the Difference Between Primary Key Constraints and Unique Key Constraints?” Answer: “Primary Key (PK) Constraints enforce uniqueness just like Unique Key (UK) Constraints,…

Interview Question of the Week #009 – Is GO T-SQL Statement?

March 1, 2015

Pinal Dave

SQL Interview Questions and Answers

SQL Command, SQL Scripts, SQL Server

I often get this question in the email – more frequently than I would like to get.
Question: “Is GO T-SQL statement?”

Interview Question of the Week #008 – Write Scripts to Convert String to Title Case or Proper Case

February 22, 2015

Pinal Dave

SQL Interview Questions and Answers

SQL Scripts, SQL Server, SQL String

Just received a question in an email asking questions about how to Convert String:

“I just got out of the interview and I was asked to write scripts to convert a string to Title Case. I was also asked to refer to the website over here to validate my answer after I complete writing script.

Do you think it is not fair to ask such questions in an interview?”

Interview Question of the Week #007 – How to Reindex Every Table of the Database?

February 15, 2015

Pinal Dave

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

SQL Scripts

Some questions are extremely popular questions and they never get old. Here is one such question which I see very often asked to DBAs in their early career. Question: How to re-index every table of the database? Answer: Well, The answer of this question can be only given in the form of the…

Interview Question of the Week #006 – Is Shrinking Database Good or Bad?

February 8, 2015

Pinal Dave

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

Shrinking Database

Here is the most debated Interview Question – Is Shrinking Database Good or Bad? I will try to answer this in a single statement – “Shrinking Database is bad practice for performance as it increases fragmentation. It should be used in rare cases of running out of space on drive.” I believe above…