Free 1z0-148 sample questions

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

• The IN parameters must not include BLOB, CLOB, collection or record data types.
• The function must be created with invoker’s rights or in an anonymous block.
• The function must be declared as a pipelined table function.
• The function must have an OUT or an IN OUT parameter.

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.)

• When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same sessio
• When the amount of memory allocated for the result cache is increase
• When the function is executed in a session frequently with the same parameter value
• When the database administrator disables the result cache during ongoing application patching
• When the maximum amount of server result cache memory that can be used for a single result is set to 0.

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

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?

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

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

• OCINumber * compareAndSum (OCIExtProcContext *ctx, OCINumber *p1, OCINumber *p2, OCINumber *p3);
• OCINumber compareAndSum (OCIExtProcContext *ctx, OCINumber p1, OCINumber p2, OCINumber *p3);
• int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, OCINumber *p3);
• int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, OCINumber p3);
• int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, int p3);
• int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, int* p3);
• OCINumber compareAndSum (OCIExtProcContext *ctx, OCINumber p1, OCINumber p2, OCINumber p3);