READ Free Dumps For Oracle- 1z0-146
Question ID 2855 | The PLSQL_OPTIMIZE_LEVEL parameter is set to 2 for the session. |
Option A | A. Only the call to the P2 function with BOOLEAN as the argument is inlined. |
Option B | B. INLINE pragma affects both the functions named P2 and is called inline. |
Option C | C. Only the call to the P2 function with PLS_INTEGER as the argument is inlined. |
Option D | D. None of the functions are inlined because inlining is not supported for overloaded functions. |
Correct Answer | B |
Question ID 2856 | 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 |