Oracle Database Advanced PL SQL 12c 1z0 148

Question : 42 of 54

Marks: +1, -0

Examine the structure of the EMP table:

Examine this code and statements:

Which statement is true?

The result cache gets invalidated after the ALTER FUNCTION and again after the second UPDATE statement.
The result cache gets invalidated after the ALTER FUNCTION and again after each UPDATE statement.
The result cache gets invalidated only after the ALTER FUNCTION statement.
The result cache does not get invalidated at all since the RELIES_ON clause is not used.
The result cache gets invalidated only after each UPDATE statement
The result cache gets invalidated only after the second UPDATE statement.

Go to Question:

Prev Question

Next Question