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 1 of 3.

1. Question 1: Which two tasks should be created as functions instead of as procedures? (Choose two.)
2. Question 6: Which two statements are true about triggers? (Choose two.)
3. Question 9: Which three statements are true about wrapping? (Choose three.)
4. Question 11: Which three statements are true about anonymous blocks and subprograms? (Choose three.)
5. Question 17: Which two statements are true about the instead of triggers? (Choose two.)
6. Question 18: User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database. SCOTT creates the following trigger: C…
7. Question 22: Examine the following snippet of code from the DECLARE section of PL/SQL DECLARE - Cust_name VERCHAR2 (20) NOT NULL : = Tom Jones: Same_name cust_name%TYPE: Wh…
8. Question 25: Which statement is true about transactions in PL/SQL?
9. Question 40: Which two statements are true about the continue statement? (Choose two.)
10. Question 41: In which of the following scenarios would you recommend using associative arrays?