Cisco Interview Question

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