Some of the questions that I remember are ,

1. What is the function of Parse in Dynamic SQL.
2. What is the function of Execute in Dynamic SQL.
3. One trigger question as mentioned below in my previous mail.
4. User wants to compile all program units at one time in PL/SQL. What command can the user use.

1. dbms_sql.parse ?
2. dbms_execute ?
3. MAX_OPEN_CURSORS ?
4. exec dbms_utility.compile_schema ?