Home
Oracle
1Z0-149 Exam Info
1Z0-149 Exam Questions

Home ❯
Oracle ❯
1Z0-149 Exam Info ❯
1Z0-149 Exam Questions

Unlock Oracle Database 19c: Program with PL/SQL Mastery: Your 1Z0-149 Success Blueprint

Aspiring database wizards, your journey to Oracle excellence starts here! Conquer the 1Z0-149 exam with our meticulously crafted practice questions, available in PDF, web-based, and desktop formats. Don't let complex PL/SQL concepts hold you back from that coveted certification and lucrative career opportunities. Our comprehensive materials, developed by industry veterans, simulate real exam scenarios, boosting your confidence and readiness. With thousands of successful candidates already benefiting, you're joining a community of future database administrators and developers. Time is ticking, and high-paying roles await invest in your future today. Whether you prefer studying on-the-go, online, or offline, we've got you covered. Take the first step towards becoming an indispensable asset in the world of Oracle database management. Your success story begins with a click!

Page: 1 /
Total 65 questions

Unlock 65 Premium Questions Get Free Questions & Answers PDF

Question 1

Which three are true about anonymous blocks and subprograms? (Choose three.)

ANamed subprograms cannot be called from other packages.

BPROCEDURE subprograms can accept parameters.

CA FUNCTION subprogram must return one or more values.

DAnonymous blocks cannot use packaged variables.

ENamed subprograms are stored in the database server.

FAnonymous blocks must always start with the Declare keyword.

GFUNCTION subprograms must be called and passed through one or more parameters.

Correct : B, C, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ANamed subprograms cannot be called from other packages.

BPROCEDURE subprograms can accept parameters.

CA FUNCTION subprogram must return one or more values.

DAnonymous blocks cannot use packaged variables.

ENamed subprograms are stored in the database server.

FAnonymous blocks must always start with the Declare keyword.

GFUNCTION subprograms must be called and passed through one or more parameters.

0 / 1500

Question 2

Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

AOption A

BOption B

COption C

DOption D

Correct : C, D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AOption A

BOption B

COption C

DOption D

0 / 1500

Question 3

Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

AIt will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

BIt will return an error at line 2.

CIt will return an error at line 3.

DIt will return an error at line 8.

EIt will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

BIt will return an error at line 2.

CIt will return an error at line 3.

DIt will return an error at line 8.

EIt will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

0 / 1500

Question 4

Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

AIt will set all salaries to 0 if it executes successfully.

BIt will always return a compile time error because it lacks an EXCEPTION section.

CIt might return a run time error depending on who invokes it.

DIt will always automatically initialize v_raise.

EIt will set all salaries to NULL if it executes successfully.

FIt will always return a run time error because v_raise is not initialized.

Correct : D, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt will set all salaries to 0 if it executes successfully.

BIt will always return a compile time error because it lacks an EXCEPTION section.

CIt might return a run time error depending on who invokes it.

DIt will always automatically initialize v_raise.

EIt will set all salaries to NULL if it executes successfully.

FIt will always return a run time error because v_raise is not initialized.

0 / 1500

Question 5

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

ADDL

BAFTER AUDIT

CBEFORE ANALYZE

DSHUTDOWN

ESERVERERROR

FSTARTUP

GBEFORE GRANT

Correct : D, E, F

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ADDL

BAFTER AUDIT

CBEFORE ANALYZE

DSHUTDOWN

ESERVERERROR

FSTARTUP

GBEFORE GRANT

0 / 1500

Page: 1 / 13
Total 65 questions

Want to Unlock Everything for
Oracle 1Z0-149 Exam?

By upgrading to Premium Access, you’ll instantly unlock:

Unlock 65 Premium Questions

Exam Name: Oracle Database 19c: Program with PL/SQL
Exam Code: 1Z0-149
Last Update: 22-Mar-2026
Formats: PDF, Web-based,
Desktop Practice
24/7 Customer Support

Price: $59 (PDF Format)

Get Full Access Now

Marked Questions
1Z0-149 Exam

1Z0-149 Exam Question 1
1Z0-149 Exam Question 2
1Z0-149 Exam Question 3
1Z0-149 Exam Question 4
1Z0-149 Exam Question 5

Download PDF File Demo

Try Web-Based Exam Practice Software Demo

Commenting

In order to participate in the comments you need to be logged-in.
You can sign-up or login