Here are some interview questions on Oracle Architecture:
Explain the difference between BITMAP Index and BTREE Index.
Explain the various large object types in Oracle
Explain the points of difference between snapshot and materialized view.
These were just a few. Watch out for more. See all questions under the Oracle Category.