Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso ETS (Princeton, NJ) nel mese di giu 2015
Colloquio
Not difficult. 6 people came for the in person interview. 2 managers. Director might come as well if he is in the office. Not hard at all but not easy as well.
Oracle Related. Troubleshooting, backups, patching etc
Describe various oracle states
How to change sql plan
What are optimizer hints and how to use them
Why use RMAN catalog
Connection pooling
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso ETS nel mese di feb 2015
Colloquio
There was a very intense Q&A session on extremely detailed questions about why Oracle does what it does executing SQL code. It appeared right away there are serious issues with the application code and the DBA's spend most of their time chasing down badly written SQL.
Domande di colloquio [1]
Domanda 1
Explain why the Oracle Cost Based Optimizer chooses the execution plans for SQL and explain the different options used and what their impact is on performance?
