Oracle 1Z0-149 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-149
Exam Name/Title: Oracle Database 19c: Program with PL/SQL
Certification Provider: Oracle
Corresponding Certification: Oracle Database PL/SQL Developer Certified Professional

Exam Questions: 67
Updated On: Aug 10, 2026

Question #1

Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

A. If set to NATIVE, programs are stored in platform dependent machine code.

B. If set to NATIVE, programs are stored in a PL/SQL bytecode format.

C. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.

D. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

E. The default value is NATIVE.

Discussion 0

Correct Answer: A,D Vote an answer

Question #2

In which type of trigger can :OLD and :NEW identifiers be used?

A. AFTER STATEMENT

B. AFTER SUSPEND

C. BEFORE STATEMENT

D. ROW

Discussion 0

Correct Answer: D Vote an answer

Question #3

Which two are true about exception handling? (Choose two.)

A. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

B. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.

C. Internally defined exceptions can be handled only by the OTHERS exception handler.

D. All declared exceptions are raised implicitly by the runtime system.

E. Predefined exceptions are globally declared in the standard package.

Discussion 0

Correct Answer: A,E Vote an answer

Question #4

Examine this code:

What will be the outcome?

A. It will result in an error as the range of the error code can only be from "-1000 to -2000."

B. It will result in an error as the range of the error code can only be from "-20000 to -20999."

C. It will execute successfully and will display the user-defined error message.

D. It will result in an error as the range of the error code can only be from "-2000 to -2999."

Discussion 0

Correct Answer: B Vote an answer

Question #5

Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

A. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

B. It will fail only at line 7.

C. It will fail at lines 6 and 7.

D. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

Discussion 0

Correct Answer: B Vote an answer

Question #6

Which three are true regarding code based access control (CBAC)? (Choose three.)

A. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

B. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.

C. In a multitenant environment, the DELEGATE option of CBAC cannot be used.

D. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.

E. CBAC roles can be granted to a program unit only if they are directly granted to its owner.

F. You can use CBAC to attach database roles to a PL/SQL function or procedure only.

G. CBAC cannot be used to secure definer's rights.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #7

Which is true about the PLSCOPE_SETTINGS parameter?

A. It is deprecated in Oracle 12c.

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

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

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

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 1Z0-149 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-149 exam.