Oracle interview question

1. Sql queries for various operations