Scenario 3: How to perform a Complete Database Recovery

It has been a long time as I completely forgotten to blog a new post. So as a DBA, everyone should know how to perform a complete databa... Read more »

Scenario 2: What will you do if a SQL statement preferably an Update Statement is taking a long time to execute ?

Hi guys, This is a one of the most common Oracle DBA interview questions you will most likely to expect if you are going to attend a tec... Read more »

Scenario 1: What will you do if the TEMP datafile is full and there is a query to be executed and it requires the TEMP datafile ?

This is one of the questions I received when I faced my first interview as an Oracle DBA. This is quite a challenging question if you ar... Read more »