Oracle Database 11g: Program with PL/SQL Free Practice Exam Questions

29 real Oracle Database 11g: Program with PL/SQL exam questions with answers and AI explanations. Oracle certification prep — page 2 of 3.

1. Question 43: Which two statements are true about the handling of internally defined or user-defined PL/SQL exceptions? (Choose two.)
2. Question 44: Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)
3. Question 45: Consider the following scenario: Local procedure a calls remote procedure B. Procedure A was compiled at 8 AM. Procedure A was modified and recompiled at 9 AM.…
4. Question 46: Which statements are true about database triggers? (Choose all that apply.)
5. Question 49: What is the correct definition of the persistent state of a packaged variable?
6. Question 52: Which two statements correctly differentiate functions and procedures? (Choose two.)
7. Question 55: Which type of exceptions is qualified as nonpredefined Oracle server errors?
8. Question 56: Examine the following command: SQL>ALTER SESSION - SET plsql_warnings * 'enable: severe', 'enable: performance', 'ERROR: 05003'; What is the implication of the…
9. Question 57: Identify two situations where the DBMS_SQL package should be used. (Choose two.)
10. Question 58: You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table. Which tw…