Oracle Database: Advanced PL/SQL Free Practice Exam Questions

34 real Oracle Database: Advanced PL/SQL exam questions with answers and AI explanations. Oracle certification prep — page 1 of 4.

1. Question 1: Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)
2. Question 2: Which three are true about functions and procedures? (Choose three.)
3. Question 3: Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)
4. Question 4: Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
5. Question 5: Which two are true about INDEX-BY tables? (Choose two.)
6. Question 6: Which statement is true about user-defined records?
7. Question 9: Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
8. Question 10: Which three are true about anonymous blocks and subprograms? (Choose three.)
9. Question 11: Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
10. Question 13: Which three are valid PL/SQL variable names? (Choose three.)