Free Oracle 1Z0-149 Practice Test & Real Exam Questions

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 15, 2026

Question #29

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

A. Explicit cursor can return more than one record.

B. %Isopen is always false in Explicit Cursor.

C. %Isopen is always false in Implicit Cursor.

D. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

E. Implicit cursor returns only one record.

F. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

G. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

Discussion 0

Correct Answer: A,C,F Vote an answer

Question #30

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

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

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

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

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

E. The default value is NATIVE.

Discussion 0

Correct Answer: B,D Vote an answer

Question #31

Which three are true about the procedure overloading feature? (Choose three.)

A. Each procedure must use positional notation to specify the corresponding actual parameters.

B. Each procedure's formal parameters must differ in name.

C. Each procedure can be a nested subprogram.

D. Each procedure's formal parameters can differ in data type or name.

E. Each procedure can be a standalone subprogram.

F. Each procedure can be a packaged subprogram.

G. Each procedure must use named notation to specify the corresponding actual parameters.

Discussion 0

Correct Answer: A,D,F Vote an answer

Question #32

Which statement is true about user-defined records?

A. Field types must match column types.

B. The number of fields must match the number of columns in a table.

C. Field names must match selected column names.

D. They can be returned from a function.

Discussion 0

Correct Answer: B Vote an answer

Question #33

Which three are true about functions and procedures? (Choose three.)

A. In a function every RETURN statement must specify an expression.

B. The ACCESSIBLE BY clause can be used only for procedures.

C. Both can have only constants as actual parameters for IN mode parameters.

D. In a procedure the RETURN statement cannot specify an expression.

E. In a function, every execution path must lead to a RETURN statement.

F. Both can be invoked from within SQL statements.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #34

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

A. INSERT

B. CREATE

C. ALTER

D. DELETE

E. UPDATE

F. DROP

G. SELECT

Discussion 0

Correct Answer: A,E,G Vote an answer

Question #35

Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

Discussion 0

Correct Answer: A 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.