What DBA activities did you to do today?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

1. What DBA activities did you to do today?

This is a loaded question and almost begs for you to answer it with "What DBA activities do you LIKE to do on a daily basis?." And that is how I would answer this question. Again, do not get caught up in the "typical" day-to-day operational issues of database administration. Sure, you can talk about the index you rebuilt, the monitoring of system and session waits that were occurring, or the space you added to a data file, these are all good and great and you should convey that you understand the day-to-day operational issues. What you should also throw into this answer are the meetings that you attend to provide direction in the database arena, the people that you meet and talk with daily to answer adhoc questions about database use, the modeling of business needs within the database, and the extra time you spend early in the morning or late at night to get the job done. Just because the question stipulates "today" do not take "today" to mean "today." Make sure you wrap up a few good days into "today" and talk about them. This question also begs you to ask the question of "What typical DBA activities are performed day to day within X Corporation?"

(Continued on next question...)

Other Job Interview Questions

• What is an Index?
• Implicit Cursor attributes
• When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -How do you correct it?
• What causes the "snapshot too old" error? How can this be prevented or mitigated?
• Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
• Explain about horizontal, Vertical tool bar canvas views?
• What is a SQL * NET?
• How can we implement roles?
• What does ROLLBACK do?
• What is coordination Event?
• More...