READ Free Dumps For Oracle- 1z0-146
| Question ID 20578 | Examine the structure of the table:
Null |
| Option A | Null |
| Option B | An empty locator |
| Option C | A non-null value |
| Option D | Either null or any non-null values |
| Correct Answer | C |
| Question ID 20579 | Which two statements are true about REF CURSOR types? (Choose two.) |
| Option A | REF CURSOR types cannot be defined inside a package |
| Option B | SYS_REFCURSOR can be used to declare cursor variables in stored procedures and functions |
| Option C | A REF CURSOR return type can be delcared using %TYPE or %ROWTYPE or a user-defined record |
| Option D | Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function |
| Correct Answer | B,C |