Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Oracle
  3. Oracle Database PL/SQL Developer Certified Professional
  4. 1z0-149 - Oracle Database 19c: Program with PL/SQL

Oracle 1z0-149 Oracle Database 19c: Program with PL/SQL Exam Practice Test

Demo: 9 questions
Total 65 questions
Get 1z0-149 Full Access Download 1z0-149 PDF

Oracle Database 19c: Program with PL/SQL Questions and Answers

Question 1

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.

Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

Options:

A.

Error in inner block

B.

Error in inner block Error in outer block

C.

Error in inner block Error in calling block

D.

Error in inner block Error in outer block Error in calling block

Question 2

Examine this code:

What will be the outcome?

Options:

A.

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

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 “-1000 to -2000.”

D.

It will result in an error as the range of the error code can only be from “-2000 to -2999."

Question 3

Examine these statements which execute successfully:

Which anonymous block executes successfully?

Options:

A.

B.

C.

D.

Question 4

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:

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

Which two will execute successfully? (Choose two.)

Options:

A.

Call HR.HELPER.H1 from the HR schema.

B.

Call HR.HELPER.H1 from the SH schema.

C.

Call HR.API.P1 from the HR schema.

D.

Call HR.API.P1 from the SH schema.

E.

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

Question 5

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

Options:

A.

B.

C.

D.

Question 6

Which three statements are true about passing parameters to subprograms? (Choose three.)

Options:

A.

PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

B.

IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

C.

IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

D.

The actual parameter must be a variable when calling a subprogram with an OUT parameter.

E.

IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

F.

OUT parameters returning values to calling subprograms act like constants in the called subprogram.

G.

Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

Question 7

Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

Options:

A.

PL/SQL code can be compiled and executed based on different versions of the operating system.

B.

PL/SQL code can be compiled and executed based on different versions of Oracle.

C.

It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

D.

Conditional compilation is disabled by default.

E.

The PL/SQL compiler can conditionally include selected parts of a program.

Question 8

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

Options:

A.

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

B.

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

C.

Package specifications can be compiled without their bodies.

D.

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

E.

A package definition must have a specification and body.

Question 9

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

Options:

A.

printer_name#

B.

1to7number

C.

yesterday's_date

D.

leap$year

E.

Number_of_days_between_March_and_April

F.

#printer_name

G.

v_fname

Load More 1z0-149 Questions
Demo: 9 questions
Total 65 questions
Get 1z0-149 Full Access Download 1z0-149 PDF