READ Free Dumps For Oracle- 1z0-146
Question ID 2857 | Examine the structure of the TEXT_TAB table. TEXT_ID NUMBER |
Option A | A. It executes successfully. |
Option B | B. It gives an error because VARCHAR2 should be explicitly converted to CLOB. |
Option C | C. It gives an error because CLOB variables should be initialized to EMPTY_CLOB(). |
Option D | D. It gives an error because the concatenation operator cannot be used with the CLOB data type. |
Correct Answer | A |
Question ID 2858 | In which two situations is the body of a result-cached function executed? (Choose two.) |
Option A | A. if the memory allocated for the result cache is increased |
Option B | B. if a session on this database instance invokes the function with the same parameter values |
Option C | C. if the first time a session on this database instance invokes the function with a parameter value |
Option D | D. if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function |
Correct Answer | C,D |