1Z0-148 Online Practice Questions and Answers

You have an external C procedure stored in a dynamic-link library (DLL). The C procedure takes an integer as argument and returns an integer. You want to invoke the C procedure through a PL/SQL program.

View the Exhibit.

Which statement is true about the C_OUTPUT PL/SQL program?

A. It invokes the external C procedure.

B. It only publishes the external C procedure.

C. It fails because the external C procedure is not published.

D. It fails because the input data type is BINARY_INTEGER and the external C procedure expects an integer.

View the Exhibit and examine the settings for the PLSQL_CODE_TYPE parameter.

After sometime, the user recompiles the procedure DISPLAY_SAL_INFO by issuing the following command:

SQL> ALTER PROCEDURE display_sal_info COMPILE;

Which statement would be true in this scenario?

A. The procedure would be invalidated.

B. The procedure would remain as NATIVE code type.

C. The procedure would be changed to INTERPRETED code type.

D. The command would produce an error and the procedure must be compiled using the PLSQL_CODE_TYPE attribute with value INTERPRETED.

Which three statements are correct with reference to intra unit inlining?

A. Inlining will always decrease the size of a unit.

B. Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.

C. You cannot inline an external subroutine.

D. Programs that make use of smaller helper subroutines are good candidates for inlining.

E. Pragmas apply only to calls in the next statement following the pragma.

F. You cannot inline local subroutines.

Examine this block of code used to calculate the price increase for all the productivity by 1% and then by 2%.

What will be the outcome on execution?

A. It will give an error because the calculated column in the cursor is not using a column alias in this block.

B. It will go into an endless loop because the loop exist condition is missing.

C. It will display the price increase by 1% only for all the products.

D. It will display the price increase by 1% only for the first product.

E. It will give an error because PDT_REC is not declared.

Which two statements are correct in Oracle Database 12c?

A. For native compilation, PLSQL_OPTIMIZE_LEWVEL should be set to 2.

B. Native compilation is the default compilation method

C. Native compilation should be used during development.

D. Natively compiles code is stored in the SYSTEM tablespace.

E. To change a PL/SQL object from interpreted to native code, set the PLSQL_CODE_TYPE to NATIVE and recompile it.

Examine this code: What is the correct statement to get the value of attribute ACCOUNT_MGR after the procedure has been executed?

A. SELECT USERENV (`ACCOUNT_MGR') FROM dual;

B. SELECT SYS_CONTEXT (`USERENV', `ACCOUNT_MGR') FROM dual;

C. SELECT SYS_CONTEXT (`ORDER_CTX', `ACCOUNT_MGR') FROM dual;

D. SELECT SYS_CONTEXT (`ACCOUNT_MGR', `ORDER_CTX') FROM dual;

E. SELECT USERENV (`ORDER_CTX') FROM dual;

Select a valid reason for using VARRAYS.

A. When the amount of data to be held in the collection is widely variable.

B. As a column in a table when you want to retrieve the collection data for certain rows by ranges of values.

C. When you want to delete elements from the middle of the collection.

D. As a column in a table when you want to store no more than 10 elements in each row's collection.

Examine these statements:

Which two corrections will allow this anonymous block to execute successfully?

A. Add wk# .NEXT; before the 7thline.

B. Add i PLS_INTEGER; before the 3rdline.

C. Add wk#. EXTEND (1); before the 5thline.

D. Change line #2 to wk# tp_test# := tp_test# (tp_rec# ());

E. Replace lines 5 and 6 with wk# (i) := tp_rec# (i, i);

Which statement is true in regard to minimizing attack surface during application design?

A. Reusable components should be developed and used extensively.

B. Only one user account should be used.

C. All the code should run anonymously.

D. Private functions and procedures should be declared in package specifications.

The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2

and DEPARTMENT_ID of data type NUMBER.

There are six employees in DEPARTMENT_ID, 20.

Examine this code:

What will be the outcome on execution?

A. The execution of this code will fail with an invalid cursor error and not display either output message.

B. The number of employees will be displayed as six for both output messages.

C. The number of employees will be displayed as six for the first output message and zero for the second output message.

D. The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.