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
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
- Introduction
- Part 1
- Part 2
- Part 3
- Part 4
- Part 5
- Part 6
- SQL Server Interview Questions and Answers Complete List Download
Reference: Pinal Dave (https://blog.sqlauthority.com)
216 Comments.
Hi Pinal,
You are helping others is really good.
Can you please let me know, that how to use current index scan and current index seek?
hai, I m vikas
plz send me common question,which may be ask in interview of sql server2005.
Thanks.
hi pinal ,can you please send me all the interview queation that can be ask in interview thanks,,,,,
Hi Pinal,
Do you write classic ASP questions too?
Hi,
I am a SQL SERVER DBA .I am working in a Multinational Company as a contractual employee. I have three years of work Experience and i am looking for a change……….
Thanks & Regards
Dhritiman Banerjee
please,send me 2007 sql interview question
hi
i m working in ISPL (IT company) as contractual employee. 1.5yrs experience.
please send me sql and pl/sql interview question and asp.net with c# interview question.
hai,
How to retrieve one last row from the single table, in Sql server.
I tried with the query as follows:
Select * from(Select top 1 * from order Order By orderdate DESC) AS last
Select Top 1 * from oder order by orderdate DESC;
But it is showing error like:
“You cannot use the orderby clause in the derived table”
Can you please clear the ambiguty
Thank You.
Hi,
I am software developer having experience of 3 years.
I am interested in your question bank.
please send me sql and pl/sql interview question and asp.net with c# interview question.
Thank You.
send to me an interview questions,i have skills on accounting and finance,and i have got opportunity for interview on bank firm.please
Could you please send the interview questions to my email address. Thanks for the help.
Hi,
I am software Engineer having experience of 2 years.
I am interested in your question bank.
Pls Send me SQL And Pl/SQL Interview questions and Answers
and Asp.net With C#
Thank You.
Pls send me SQL Server 2000 as well Oracle 9i interview question .
Hi Pinal,
I am a software developer looking for new opening now.
plz send me common question,which may be ask in interview of sql server2005.
Thanks,
Roopa
Pl. send me all set of Interview Prep. Questions.
Hi Pinal,
I am a software developer looking for new opening now.
plz send me common question,which may be ask in interview and Objective type question also.
Thanks,
Rajesh
hello sir lokesh her i like ur questions plz send me full questions with answers on my id lokesh143kumar20022yahoo.com
Hi,
I am a software developer looking for new opening now.
plz send me common question,which may be ask in interview and Objective type question also.
Thanks,
Kshitij
My Email ID- kshitijmaheshwari@yahoo.com
Hi,
please send me basic & intermediate level interviews question.
And sir if can be possible answers with them then please send
also.
Thanx with Regard
Prince Saurabh
Hi,
Please send me the difference between SQL server 2005 and SQL Server 2008