When hiring Oracle DBAs and developers, a lot of questions are asked about Oracle view. Although view is only one of Oracle objects and it is not that significant in my opinion, for some reason managers and business users love views, therefore in interview they usually like to ask more questions on Oracle views. The following are some of questions and answers for you to prepare: (more…)
Look at the business facts:
Database is the heart of today’s enterprise.
The whole IT business works around databases.
Oracle is the leading enterprise database server.
That makes an Oracle Database Administrator (DBA) so special. As you can see, Oracle DBAs play critical roles in IT, no doubt that experienced DBAs are in high demand and get paid well. (more…)
This is a technical interview question to getting your insight of detailed skill sets as an Oracle DBA or developer. Your answer could tell what level of experience in database server and SQL query performance tuning. Your answer could be: (more…)
If you were certificated by Oracle in 9i, you only need to pass one upgrade new feature exam to get Oracle 10g DBA certification. The exam is easy because it only tests the basic knowledge of Oracle 10g. Also, a lot of knowledge of the new feature are not really new, you already learned a lot of them from the previous version. Anyway, the following list shows the terminologies and concepts that got to be tested in the new feature exam. Make yourself familiar with them. Check the Oracle documentation or search online if you are not clear. Then you are ready to pass. Good luck! (more…)