READ Free Dumps For Oracle- 1z0-146
| Question ID 2791 | View the Exhibit and examine the PL/SQL code. The code takes a long time to execute. What would you recommend to improve performance? COMMIT;
|
| Option A | A. using NOT NULL constraint when declaring the variables |
| Option B | B. using the BULK COLLECT option for query instead of cursor |
| Option C | C. using WHILE.. END LOOP instead of FOR .. END LOOP |
| Option D | D. using the SIMPLE_INTEGER data type instead of the NUMBER data type |
| Correct Answer | B |
| Question ID 2792 | Which statements are true about internal LOBs? (Choose all that apply.) |
| Option B | A. They cannot use redo logging. |
| Option C | B. They can be used as attributes of a user-defined data type. |
| Option D | C. They cannot be passed as parameters to PL/SQL subprograms. |
| Option E | D. They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column. |
| Correct Answer | B,D |