Cognizant Interview Question

How does oracle optimzer executes a query?