READ Free Dumps For Oracle- 1z0-146
| Question ID 2861 | Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package? (Choose two.) |
| Option A | A. OPEN can be used to open only internal LOBs in the indicated mode. |
| Option B | B. FILEOPEN can be used to open only external LOBs in the indicated mode. |
| Option C | C. OPEN can be used to open internal and external LOBs in the indicated mode. |
| Option D | D. FILEOPEN can be used to open internal and external LOBs in the indicated mode. |
| Correct Answer | B,C |
| Question ID 2862 | When do you use static SQL as a technique for avoiding SQL injection? |
| Option A | A. when the WHERE clause values are unknown |
| Option B | B. when the code contains data definition language (DDL) statements |
| Option C | C. when all Oracle identifiers are known at the time of code compilation |
| Option D | D. when the SET clause values are unknown at the time of code compilation |
| Correct Answer | C |