Envié una solicitud electrónica. El proceso duró 2 semanas. Acudí a una entrevista en ETS (Princeton, NJ) en jun 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
Solicité el puesto a través de un captador. El proceso duró 1 día. Acudí a una entrevista en ETS en feb 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.
Preguntas de entrevista [1]
Pregunta 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?
