Some Intreview questions

  • Hi,

    i had been asked some questions by interviewer, which i wanted to know the answers.

    I already googled up the answers and couldnt find some.

    1.What precautions will you take before updating a million rows in a table in a production database.?

    2.what differences are in the results if we do sp_who2/who or run a DMV?

    3. How to know who inserted/deleted/modified any things in a table OTHER than by using trigger?

    4. If our users are running sprocs daily through any applicaton; what will you create to see the performances of those sprocs

    on a daily basis?

    5. If we run a query select * from where order by...example of a query.

    What is the order of execution we will see in a Query execution plan ?

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

  • SKYBVI (7/21/2012)


    1.What precautions will you take before updating a million rows in a table in a production database.?

    That's asking for what you do. So, what precautions do *you* take before updating a million rows in a production database? Think about what can go wrong.

    2.what differences are in the results if we do sp_who2/who or run a DMV?

    That you can test

    3. How to know who inserted/deleted/modified any things in a table OTHER than by using trigger?

    Google: SQL Auditing

    4. If our users are running sprocs daily through any applicaton; what will you create to see the performances of those sprocs

    on a daily basis?

    Google: SQL performance monitoring

    5. If we run a query select * from where order by...example of a query.

    What is the order of execution we will see in a Query execution plan ?

    That you can test. Start management studio, write such a query, look at the exec plan.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • In continuation to what Gail said...

    1.What precautions will you take before updating a million rows in a table in a production database.?

    Google: Backup, Locking / Blocking & Commit / Rollback.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply