SQL SERVER - Q and A with Database Administrators « Journey to SQL Authority with Pinal Dave

Feed on: Posts; Comments

SQL SERVER - Q and A with Database Administrators

December 2, 2007 by pinaldave

I have been in India for more than a month now, as I am leading a very large outsourcing project. We have conducted few interviews since the project required more Database Administrators and Senior Developers. I am listing few of the questions discussed during all the interviews. The whole event of interviews was very interesting. I met some very good programmers from all over the country. Many interesting questions were discussed between interviewers and candidates. I am listing some of those questions here. Some are technical and some are just my personal opinions. I will appreciate your thought about this article.

Read my complete article here.

Posted in DBA, Database, Pinal Dave, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, Software Development, T SQL, Technology | 15 Comments

15 Responses to “SQL SERVER - Q and A with Database Administrators”

on December 5, 2007 at 8:07 pm theresa

Please send me interwiew questions.
on December 14, 2007 at 9:47 pm HRIEN

Please send me interwiew questions.
on December 15, 2007 at 11:52 am prudhvik

Please send me interview questions..

Many thanks for great encouragement ……
on January 3, 2008 at 3:12 pm paresh

Please send me interwiew questions.
on February 8, 2008 at 5:14 pm Salim Akhtar

hi.
this is salim
i want to know the differnecre between primary key and unique key
on February 8, 2008 at 5:15 pm Salim Akhtar

please also send me intwerview questions
on February 14, 2008 at 11:08 pm Bhavish.B

Superb Sir You website is most help full for SQL Programmer
on March 22, 2008 at 10:41 pm Hima

Please SEnd me the questions.
on May 29, 2008 at 11:53 am ram123

Sir please send me interview Q. & Ans in sql 9i. Sir your site is very helpful.
on May 30, 2008 at 8:05 am zia

Hi Pinal,

Can you please email me the interview questions on sql server 2000 and 2005. It will be very helpful.

Regards

Zia
on June 3, 2008 at 4:52 pm Manimaran

Hi Pinal,

All Your website information/articles are most help full for SQL Developer and Administrator
on June 9, 2008 at 2:22 pm Darshan shah

Primary key and unique key both are for uniqueness of data in a row.but P.K. dose not allow null values where unique key allow it.

when we define P.K on column at that time cluster index is created automatically. where while creating Unique key non cluster index is created.
on June 9, 2008 at 2:23 pm Darshan shah

Hi Salim

Primary key and unique key both are for uniqueness of data in a row.but P.K. dose not allow null values where unique key allow it.

when we define P.K on column at that time cluster index is created automatically. where while creating Unique key non cluster index is created
on June 9, 2008 at 2:25 pm Darshan shah

Hi pinal
I want to give exam for sql server DBA 2000 . so can u please guide me how to do preparation for that.and tell me how can i get the material for that and from .

Thanks
Darshan shah
dksit_05@yahoo.com
on July 1, 2008 at 3:36 pm Giorgos Taskos

Please send me the questions.

Thank you.