SQL Server Interview Questions and Answers – Introduction

Interview Questions and Answers are now updated with the latest questions and answers. New Location:  SQL Server Interview Questions and Answers.

Click here to get free chapters (PDF) in the mailbox

Interview Questions and Answers

SQL Server Interview Questions and Answers - Introduction interview

Hello All,

Thank you all for sending requests for Questions and Answers. It begins from today. This is a six part series. I will update this post once all the six parts are published.

Thank you to the regular reader (name not published as per request) who sent me a new banner for this blog. I hope you all like it.

I have done my best to answer all the emails and comments I have received. Only those comments are published which are adding something more to the original post.

I always welcome email/comments, whether you’re interested in talking about my projects, MS SQL SERVER, ColdFusion, Web Architecture, or have taken an online tutorial class of mine, or even have an event where you believe I’d be a great speaker or panelist. Or just feel free to say “hi” too.

Complete Series of SQL Server Interview Questions and Answers

Reference: Pinal Dave (https://blog.sqlauthority.com)

Database, DBA, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Trigger
Next Post
SQL Server Interview Questions and Answers – Part 1

Related Posts


  • Hey Dave…

    I am an Oracle DBA. Interested to learn sqlserver. If possible please provide the study material pdfs.

    Thanks inadvance,

  • srikanthreddy
    June 11, 2008 10:55 am

    Pllease send me the SQL server interview questions

  • tamilselvan k
    June 11, 2008 2:07 pm

    hi dave..
    am interested to sql server …if possible reply me…
    how to select second max value of table
    thank u ..

  • Hai

    Please send me SQL server interview questions

  • Could you please send me the SQL Server interview questions?



  • Hi,
    This wesite is really fantastic. post and comments links are not working.
    Kindly answer the below questions abou SQL:-
    1. How to update the content of the table, with tedious condition?
    2. There are two tables C1(a1, a2) and C2(a3,a4), how to write a query to create one new table let say C3 with the column of (a1,a2,a3,.a4)?
    3. Consider student table contain name of the subjects as sub1, sub2,sub3 and average marks. Write the query to retrieve the name of the student which got highest marks in sub1?
    4. Consider an account table contains uid, password, name and activation field. Here the activation fields contain the value 0. Now write the query to make the activation field value to 1 and retrieve the row?
    Plz send me those answers to my mail id.


  • haresh gadhiya
    June 28, 2008 10:40 pm


  • hi Pinal,

    yr site is very helpful.
    i m .net programmer but as u know sometime interviewer asks for the queries….
    i m looking for queries as a tutorial.
    so,we can practice that before facing interviews.


  • Hello Sir
    I want sql and pl/sql objective type questions and also questions that are asked in interviews,also give me information where i will get good IT job oppertunities.

  • please send c# objective type question

  • hi
    i am doing six weeks training on oracle 9i module’1′ can you pls tell me the questions that were previously asked in the online test……………..
    also tell me the job scopes for a b.tech students in database…………

  • hi,
    this radhika monday i have an interview that,s why i need
    an interview questions in SQL Server.
    plz send.

  • hi i want interview questions with answers on asp.net,c#.net,vb.net,ado.net & sql server 2005.can u help me in getting job.

  • Imran Mohammed
    July 15, 2008 2:45 am

    @sreelakhsmi :

    This is for SQL SERVER, Best questions nicely answered.

    1. https://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/ – SQLAUTHORITY.com

    Hope this helps,

  • Hi,

    You are doing a valuable need and help for a better society. Thanks for Keeping everyone’s spirits high.

    Keep Going.

  • i need your interview qutions

  • I would like to know your inverview questions with answer as if now i’m new for SQL Server DBA…

    Plz send the full details of you

    Thanks & Regards

  • Hi,
    I am looking for DBA questions for practice. Please send me.


  • Hi, Thanks in advance, pls send me the interview questions

  • Hi Dave,
    Are the interview questions that are up for download to date with the SQL 2005 stuff??

Comments are closed.