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 #1

Which three are valid PL/SQL variable names? (Choose three.)

A. printer_name#

B. 1to7number

C. yesterday's_date

D. #printer_name

E. leap$year

F. Number_of_days_between_March_and_April

G. v_fname

Discussion 0

Correct Answer: A,E,G Vote an answer

Question #2

Which three are true about DDL triggers? (Choose three.)

A. They must be created in an enabled state.

B. They can be fired when a table is truncated.

C. They cannot include the WHEN clause.

D. They can be fired when a privilege is granted to a user.

E. They can be fired either before or after a DDL statement executes.

F. They must be created in a disabled state.

G. They fire only when a DDL statement is executed by the owner of the trigger.

Discussion 0

Correct Answer: B,E,G Vote an answer

Question #3

Which is true about the PLSCOPE_SETTINGS parameter?

A. It is deprecated in Oracle 12c.

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

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

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

Discussion 0

Correct Answer: C Vote an answer

Question #4

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

A. The PARALLEL_ENABLE clause can be specified for a nested function.

B. The NOCOPY hint asks the compiler to pass the actual parameters by reference.

C. A deterministic function's results always depend on the state of session variables.

D. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

E. The NOCOPY hint asks the compiler to pass the actual parameters by value.

F. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

G. A function is deterministic if it always returns the same result for a specific combination of input values.

Discussion 0

Correct Answer: B,F,G Vote an answer

Question #5

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 result in an error as the range of the error code can only be from "-2000 to -2999."

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

Discussion 0

Correct Answer: B Vote an answer

Question #6

Which three are true about PL/SQL subprograms? (Choose three.)

A. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.

B. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.

C. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.

D. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.

E. Subprograms are cached by default and shared among users, thereby reducing memory requirements.

F. A PL/SQL procedure can invoke an external code block written in a different programming language.

G. Host variables can be referenced inside any PL/SQL subprogram.

Discussion 0

Correct Answer: A,E,F Vote an answer

Question #7

Examine these statements from a block of code:

Which two are true? (Choose two.)

A. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

B. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

C. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

D. Only the PRICE column can be updated in the PRODUCTS table.

E. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

Discussion 0

Correct Answer: B,E 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.