Eirikur Eiriksson (8/6/2014) Jeff Moden (8/5/2014)
I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity
Thanks a lot :
You're the newly hired Sr. DBA for a company. There are no other DBAs. The previous DBA quit a month ago.
Explain in great detail what your first "real" day (normally, the 2nd actual day. The first actual day is usually wasted on paper work and seeing if you can handle a specimen cup without getting your hands wet, etc) will consist of.
On the 3rd "real" day, a database becomes corrupt. What actions will you take?
Another version: On the 3rd "real" day, you are told that a database "may be" corrupt. You look into it and find that it has been so for months....
"What's the sa password?"
"It's written on the whiteboard by the developers."