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