1z0-148 sample questions

Question 1

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

Accepted Answer

When the database administrator disables the result cache during ongoing application patching

Accepted Answer

When the maximum amount of server result cache memory that can be used for a single result is set to 0.

Answer

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

Answer

When the amount of memory allocated for the result cache is increase

Answer

When the function is executed in a session frequently with the same parameter value

Question 2

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

Accepted Answer

Accepted Answer

Question 3

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?

Accepted Answer

Question 4

Examine this code:

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

Accepted Answer

Accepted Answer

Question 5

Examine this external function declaration:

Which C function does it publish?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

Question 6

Examine the test_tbl table and its contents:

Examine this code:

What is the outcome of this anonymous PL/SQL block?

Accepted Answer

QRA-06502: PL/SQL: numeric or value error: invalid LOB locator specified

Answer

“It was updated” is displayed.

Answer

Successful completion without printing “It was updated”

Answer

A NO_DATA_FOUND exception is thrown.

Answer

QRA-22920: row containing the LOB value is not locked

Free 1z0-148 sample questions

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

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?

Examine the test_tbl table and its contents: Examine this code: What is the outcome of this anonymous PL/SQL block?

6 more free samples are waiting