READ Free Dumps For Oracle- 1z0-146
| Question ID 2807 | Examine the section of code taken from a PL/SQL program: |
| Option A | A. The calls to the P1 procedure are not inlined in the section commented as Call 1. |
| Option B | B. The calls to the P1 procedure might be inlined in the section commented as Call 2. |
| Option C | C. The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2. |
| Option D | D. The calls to the P1 procedure are never inlined in both the sections commented as Call 1 and Call 2. |
| Correct Answer | A,B |
| Question ID 2808 | Which statements are true about temporary LOBs? (Choose all that apply.) |
| Option A | A. They can be created only for CLOB and NCLOB data. |
| Option B | B. They can be accessed only by the user who creates them. |
| Option C | C. They generate more redo information than persistent LOBs. |
| Option D | D. They exist for the duration of the session in which they are created. |
| Option E | E. They are stored temporarily in the default tablespace of the user who creates them. |
| Correct Answer | B,D |