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.
You have a very good interview questions and answers.
thank you for summarize them.
jchen
Please Send SQL Server Interview Question ASAP
Hi………………….
Dear I urgent need of SQL Server Interview Question. Please Send ……………………………….
Please send SQL interview questions
Please send SQL interview questions !!
Hi Pinal,
I am very excited to write about you. I like the Interview questions and answers. I like your site and i would like to be in touch with you as i am new in SQL server and i have a dream to make a career in it though i am not very good programmer.
By the way where is your online tutorial class. I would love to take that.
Please mail me about your online line tutorial Details
Thank you.
Hi Pinal,
Nice work…. helpful questions.,, keep it up.
A question….
Is there any utilty which will give me list of the backup job failed for more than 2 days… I know we can find out that through backupfile, backupmediaset..
But wanted to automate that process….for more than 100 servers and almost 1000+ databases.
Planning to create a tool… somewhat like this…
Pass Server Name as a parameter…
a. Check for all available instance on that server.
b. Check all the databases on each instance and
c. Check the backupstatus of each of the DB.
To check these manually will take hell lot of time so want to automate this process. Can you suggest anything?
Thanks in Advace,
-Bhupendra
hai,
i am naushad kindly send interview questions and tutorials in SQL
Please send me the Interview Q’s and SQL tutorial
Hi pinal,
its really nice if u send me those questions n all set asap..
thanks. pinal
Hi Pinal,
requsted to u.
im completed my B.Tech from JNTU.
n looking fr S/W PROGRAMMER in SQL-2000
Plz send the SQL question n answers to my id
as soon as possible.
especially im looking fr ORACLE programmer
Hi Pinal Dave,
I am very happy to write you. I would like to know the Interview questions and answers. I would like to be in touch with you online, as i am new in SQL server and i have a dream to make a career in it though i am not very good programmer.
I need your assistance in case if i required, i will write you personally when ever i required. Can u help me to find ur online tutorial class. I would like to take part in that.
Thank you.
Hi Dave,
I have 2+ yrs experience in SQL DBA, now i’m looking for a change. I started to attend interview after 2 years. So i would like to know the latest interview ‘Q’ Bank. Practically I’m very strong, but if i get ur Q/A that would be fine.
Thank You
Hi Pinal,
While searching on google regarding SQL Server 2005,
I came across your site. And i find it really good in all way.
I ve got one que.
How to create composite primary key? if not then how to acess the records from detail table.
thanku
i want to ask u that after learning sql , which type of jobs i can do? coz now i m learning dotnet course so i mquite confused please do reply for this
thank you.
Hi PINAL!
I find your interview questions very interseting. Most important thing is that all questions are answered in brief and all answers are very easy to unsersatnd.
I am a Software Engineer, working in SQL Server 2005 & Reporting Services environment. I want to explorer my skills in SQL Server Database. Please send me more questions with anserws.
For any assistance in future I’ll write you to get answer.
Regards!
Hari
Hi
pl. send me the interview questions
regds
prasad
thank for so nice articles
Hi,
All information are very nice and if you put bit more regarding the indexes ,i think helpful to everyone .
Thanks and Regards,
Mohananu
Hi
I find your interview questions very interseting. Most important thing is that all questions are answered in brief and all answers are very easy to unsersatnd
pl. send me the interview questions
regds
siva