I am scheduled to interview candidates for an Oracle developer at my company. I'm trying come up with technical questions to test the candidates Oracle knowledge. Here's what I've come up with so far:
What is a materialized view?
A PL/SQL procedure contains the line: pragma autonomous_transaction; What does it mean and when would you use it?
What is a pipelined function?
I have a SQL statement: select * from a where a.id not in (select id from b); It's returning rows where the id is in b. What's wrong?
Any other suggestions?