Oracle interview question

Project details, Performance tuning, scenario based questions, code on different requirements