SQL SERVER – Q and A with Database Administrators

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.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

18 thoughts on “SQL SERVER – Q and A with Database Administrators

  1. Hi Pinal,

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

    Regards

    Zia

    Like

  2. 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.

    Like

  3. 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

    Like

  4. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s