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,
I really appreciate your knowledge and your effort which you put for others.
Well it wud be great if I can get your inteview questions along with the answers.
Thanks N Advance,
Priya
Manjunath Patil
Hi Pinal Dave,
I am very excited to writ 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.
If i need any assistance i will write you personally. By the way where is your online tutorial class. I would love to take that.
Thank you.
i need your sql questions and answers.
Thanks
Brajesh kumar
hi
I want complete sql server interview questions.
thanks
Hi
I would like to get sql server complete interview questions
Please do send it asap
Regards
john
Hi
I would like to get sql server complete interview questions and answers
Please do send it asap
Regards
sunil
Hi Pinal,
I am a beginner in SQL.
So it would be of great help to me if you can send me some questions on T-SQL (including queries, sp’s , etc) for the Northwind and Pubs database that ships with SQL Server. Also some questions meant for an SQL Programmer, and not a DBA.
Thanks in advance,
Jaideep.
its really nice and superb.Include some logical question for sql dba.
hi,
v.v.v.v.v. important
i have a query, but m not sure whether u will see this comment and answer to my question,…
this has been asked me in SQL interview,
A view has been created from a Single table…
by mistake this view has been dropped, which has been created with very complex queries…and there is no back kept for this view script….
so how we can protect this view from dropping…
*it is not the assigning a priviledge to the user…
*it is something to do with protecting view so that unless the table (from which view is derived) is dropped, the view can not b dropped….
plz send the interview quests of C#.net and mssql server
i m mba with finance spl . i need your help i want know some mejore point of interview q n ans.
i need introduction n all about the mba questions
Hi Pinal,
I have been working in Sql server 2005.While trying to detach the database the following error has been occured.
1.Msg 926,Level 14,State 1,Line 1
Database ‘msdb’ cannot be opened.It has been marked SUSPECT by recovery.See the Sql server errorlog for more information.
Problems recording information in the msdb..suspect_pages table were encountered.
This error does not interfere with any activity except maintenance of the suspect_pages table.Check the error log for more information.
Please guide me to rectify this problem.
Regards,
Sukumar.K
I have worked in sqlserver 2005.
After detaching the database(which i have used in sql server2005) i tried to attach the database in sql server 2000.
while attaching this error has been occured.
Server: Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Connection Broken
Can you please guide me to rectify this problem.
Regards,
Sukumar.K
nice work
Hi Pinal Dave,
I am very excited to writ 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.
If i need any assistance i will write you personally. By the way where is your online tutorial class. I would love to take that.
Regard’s
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 to my email objective type of interview questions and answer
i am waiting for your reply
regds
raja
i found sql query interview Q&A very informative of r interview
Hi Pinal,
Great work..Thanks for your Excellent informations..
comming friday i had an interview in ibm, for 10g database administrator, i neeed an interview question please help me
hai sir,
please send the interview questions of sql server 2005.
with regards,
J.Seelan