When using Oracle export/import what character set concerns might come up? How do you handle them?
How do you use automatic PGA memory management with Oracle 9i and above?
Explain two easy SQL optimizations.
Name three SQL operations that perform a SORT.
What is the difference between Truncate and Delete? Why is one faster? Can we ROLLBACK both? How would a full table scan behave after?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What does the NO LOGGING option do? Why would we use it? Why would we be careful of using it?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
What is the difference between RMAN and a traditional hotbackup?
What are bind variables and why are they important?