Login/Signup
Contact Us

Microsoft
Cisco
Oracle
Salesforce
SAP
CompTIA
Fortinet
Palo Alto Networks
Google
Nutanix
All Exams

Curious about Actual Oracle PL/SQL Developer Certified Professional (1Z0-149) Exam Questions?

Here are sample Oracle Database 19c: Program with PL/SQL (1Z0-149) Exam questions from real exam. You can get more Oracle PL/SQL Developer Certified Professional (1Z0-149) Exam premium practice questions at TestInsights.

Page: 1 /
Total 65 questions

Want more questions? Get Premium Access.

Question 1

Which is true about counter variables in a FOR loop?

AIt must explicitly be declared.

BIt can be modified in the body of the loop.

CIt cannot be NULL.

DIt is accessible outside the body of the loop.

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt must explicitly be declared.

BIt can be modified in the body of the loop.

CIt cannot be NULL.

DIt is accessible outside the body of the loop.

0 / 1500

Question 2

In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.

A row exists with EMPLOYEE_ID 201.

Examine these packages created by user HR:

1Z0-149 Exam Question 2 Exhibit 1

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.

Which two will execute successfully? (Choose two.)

ACall HR.HELPER.H1 from the HR schema.

BCall HR.HELPER.H1 from the SH schema.

CCall HR.API.P1 from the HR schema.

DCall HR.API.P1 from the SH schema.

ECreate and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

Correct : B, D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ACall HR.HELPER.H1 from the HR schema.

BCall HR.HELPER.H1 from the SH schema.

CCall HR.API.P1 from the HR schema.

DCall HR.API.P1 from the SH schema.

ECreate and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

0 / 1500

Question 3

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

AEach procedure can be a nested subprogram.

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

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

DEach procedure's formal parameters must differ in name.

EEach procedure can be a packaged subprogram.

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

GEach procedure can be a standalone subprogram.

Correct : B, E, F

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AEach procedure can be a nested subprogram.

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

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

DEach procedure's formal parameters must differ in name.

EEach procedure can be a packaged subprogram.

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

GEach procedure can be a standalone subprogram.

0 / 1500

Question 4

Which two are true about packages? (Choose two.)

AVariables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

BModifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

CPackage specifications can be compiled without their bodies.

DStandalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

EA package definition must have a specification and body.

Correct : A, C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AVariables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

BModifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

CPackage specifications can be compiled without their bodies.

DStandalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

EA package definition must have a specification and body.

0 / 1500

Question 5

Examine this statement which executes successfully:

SQL> SET SERVEROUTPUT ON;

Now, examine this code which is executed:

1Z0-149 Exam Question 5 Exhibit 1

What is true about the result?

AIt returns an error in line 2.

BIt returns an error in line 4.

CIt returns an error in line 9.

DIt executes and displays output.

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt returns an error in line 2.

BIt returns an error in line 4.

CIt returns an error in line 9.

DIt executes and displays output.

0 / 1500

Page: 1 / 13
Total 65 questions

Unlock Full
1Z0-149 Exam Features

In Just $49 You can Access

All Official Question Types
Interactive Web-Based Practice Test Software
No Installation or 3rd Party Software Required
Customize your practice sessions (Free Demo)
24/7 Customer Support

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

About us Terms And Conditions FAQ's Guarantee Privacy Policy DMCA Corporate Signup

Instagram
YouTube
Pinterest
Facebook
Quora

© Copyright Notice All contents 2024 TestInsights.com and it’s contributors - All rights reserved