READ Free Dumps For Oracle- 1z0-146
| Question ID 20614 | Which two statements are true about nested tables and varrays? (Choose two.) |
| Option A | Only varrays must have consecutive numbers as subscripts |
| Option B | Only netsted tables can be used as column types in database tables |
| Option C | Both nested tables and varrays must have consecutive numbers as subscripts |
| Option D | Both nested tables and varrays can be used as column types in database tables |
| Correct Answer | A,D |
| Question ID 20615 | See the Exhibit:
Using NOT NULL constraint when declaring the variables The code take a long time to execute. What would you recommend to improve performance? |
| Option A | Using NOT NULL constraint when declaring the variables |
| Option B | Using the BULK COLLECT option for query instead of cursor |
| Option C | Using WHILE ........... END LOOP instead of FOR ........... END LOOP |
| Option D | Using the SIMPLE_INTEGER data types instead of the NUMBER data type |
| Correct Answer | B |
