1z0-148 Free Sample Questions

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table. Under which two circumstances will the cache for this function not be used and the function body be executed instead? (Choose two.)

Which two blocks of code execute successfully? (Choose two.)

ABCDE

Examine this Java method in class Employee, loaded into the Oracle database: public static int updateSalary ( String name, float salary) { . . . } Which PL/SQL function specification can be used to publish this method?

ABCDE

Examine this code: Which two are valid correlations to the code to avoid or mitigate SQL Injection? (Choose two.)

ABCD

Examine this external function declaration: Which C function does it publish?