Good sql related question to ask for interview of senior oracle developer
Hi
I have to interview for a senior oracle developer. I am a DBA since 8 years and while I can ask always about syntax and about things like need for outer join, difference between rank and dense rank and use of having clause etc, I am looking for some thoughts on type of questions to ask to test ability to apply sql knowledge . Something like sql related scenarios or questions to ask. Can you suggest on it? Similarly can you suggest practical questions related to pl/sql - I don't intend to use this as is - but I want to refine and improve the way I interview and make it more thorough.
thanks,