READ Free Dumps For Oracle- 1z0-146
| Question ID 2811 | Which two statements are true about the initialization of internal LOBs? (Choose two.) |
| Option A | A. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs. |
| Option B | B. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non-NULL internal LOBs. |
| Option C | C. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs. |
| Option D | D. The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and EMPTY_BLOB() functions, respectively. |
| Option E | E. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size. |
| Correct Answer | C,E |
| Question ID 2812 | Which two statements are true about the tuning of PL/SQL code? (Choose two.) |
| Option A | A. Redundant SQL statements in PL/SQL code should be avoided. |
| Option B | B. Implicit data type conversion in PL/SQL code can improve performance. |
| Option C | C. Usage of the NOT NULL constraint in PL/SQL code can degrade performance. |
| Option D | D. If you have one PL/SQL program unit instead of multiple smaller executable sections, performance can be improved. |
| Correct Answer | A,C |