Which is true about the PLSCOPE_SETTINGS parameter?

It can be used to obtain information about all identifiers when compiling a procedure.

It is deprecated in Oracle 12c.

It can be used to control execution of specific portions of the PL/SQL code conditionally.

It can be used to control a user's privileges on PL/SQL objects at run time.

Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

A function definition can be modified without dropping and re-creating it.

Object privileges to execute a replaced function are retained by those users who had the privileges.

Function based indexes remain usable when replacing the function on which the index depends.

Object privileges to execute a replaced function must be regranted to those users who had the privilege.

This clause can be used only for procedures and functions.

Which three statements are true about passing parameters to subprograms? (Choose three.)

IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

The actual parameter must be a variable when calling a subprogram with an OUT parameter.

PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

OUT parameters returning values to calling subprograms act like constants in the called subprogram.

Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID. A row exists with EMPLOYEE_ID 201. Examine these packages created by user HR: EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages. Which two will execute successfully? (Choose two.)

Call HR.HELPER.H1 from the SH schema.

Call HR.API.P1 from the SH schema.

Call HR.HELPER.H1 from the HR schema.

Call HR.API.P1 from the HR schema.

Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

Free Oracle 1Z0-149 Exam Practice Questions & Explanations

Last updated on: Aug 21, 2026
Prepared & Reviewed by the ValidExamDumps Editorial Team

At ValidExamDumps, we consistently monitor updates to the Oracle 1Z0-149 exam questions by Oracle. Whenever our team identifies changes in the exam questions, objectives, focus areas or requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these up to date and 100% exam domain coverage questions, our customers can successfully pass the Oracle Database 19c: Program with PL/SQL exam on their first attempt without needing additional materials or study guides.

Other certification materials providers often include outdated or removed questions by Oracle in their 1Z0-149 exam. These outdated questions lead to customers failing their Oracle Database 19c: Program with PL/SQL exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions. Our main priority is your success in the Oracle 1Z0-149 exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.