Pregunta de entrevista de Cisco

Asked about the internal algorithm used by Oracle for nested-loop, hash & short-merge joins in SQL queries