Oracle interview question

Few basic practical questions