SQL query traversal through SGA, PGA, Network, OS, Disk. Tuning involved in each phase like Buffer, Cache, Disk IO, Parsing, etc... The interviewer was keep adding to new DB components and looking for their behaviour while executing the query.