Oracle Database 12c: Advanced PL/SQL Free Sample Questions

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.

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.

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