Free Oracle 1Z0-149 Exam Dumps Questions & Answers


Exam Code/Number:	1Z0-149Join the discussion
Exam Name:	Oracle Database 19c: Program with PL/SQL
Certification:	Oracle
Free Question Number:	67
Publish Date:	Oct 02, 2026
# of views:	6212
Rating 100%

Page: 1 / 14
Total 67 questions

Question 1

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

A.A function is deterministic if it always returns the same result for a specific combination of input values.
B.The NOCOPY hint asks the compiler to pass the actual parameters by reference.
C.The NOCOPY hint asks the compiler to pass the actual parameters by value.
D.A deterministic function's results always depend on the state of session variables.
E.The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
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.The PARALLEL_ENABLE clause can be specified for a nested function.

Question 2

Examine these statements which execute successfully:

Which anonymous block executes successfully?

Question 3

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

Question 4

Which two are true about INDEX-BY tables? (Choose two.)

A.INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
B.INDEX-BY table types can be created with the CREATE TYPE statement.
C.INDEX-BY table types can be created in PL/SQL blocks only.
D.The index can be integer only.
E.The index can be integer or string.

Question 5

Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

A.It results in an error because Authid Definer is missing from MYPROC.
B.It executes successfully.
C.It results in an error because USERB doesn't have select privilege on USERA.EMP.
D.It results in an error because Authid Current_User is missing from MYPROC.