Candidatei-me online. O processo levou 2 semanas. Fui entrevistado pela ETS (Princeton, NJ) em jun. de 2015
Entrevista
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
Candidatei-me por meio de recrutador(a). O processo levou 1 dia. Fui entrevistado pela ETS em fev. de 2015
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 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?
