Oracle interview question

database design