Oracle Database Advanced PL SQL 12c 1z0 148

Question : 12 of 54

Marks: +1, -0

Examine this code:

Users of this function may set different date formats in their sessions
Which two modifications must be made to allow the use of your session’s date format when outputting the cached result of this function? (Choose two.)

Change the RETURN type to DAT
Change AUTHID to CURRENT_USER.
Use the TO_CHAR function around SYSDATE, that is, 1_date := TO_CHAR (SYSDATE).
Change the data type of 1_date to DATE
Set NLS_DATE_FORMAT to ‘DD-MM-YY’ at the instance level.
Set the RESULT_CACHE_MODE parameter to FORCE.

Validate

Go to Question:

Prev Question

Next Question