Oracle Database 19c: Program with PL/SQL (1Z0-149) Free Practice Test

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?

A. Error in inner block Error in outer block

B. Error in inner block Error in outer block Error in calling block

C. Error in inner block

D. Error in inner block Error in calling block

Correct Answer: C

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:

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)

A. Call HR.HELPER.H1 from the SH schema.

B. Call HR.API.P1 from the HR schema.

C. Call HR.HELPER.H1 from the HR schema.

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

E. Call HR.API.P1 from the SH schema.

Correct Answer: A,E

Question 3

Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?

A.

B.

C.

D.

E.

Correct Answer: D

Question 4

Which is true about EXIT and CONTINUE statements?

A. They have the same effect on the execution of a loop.

B. They must have a WHEN condition.

C. They must use labels.

D. They can be used in any type of loop.

Correct Answer: D

Question 5

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

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

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

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

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. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

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

Correct Answer: A,C,D

Question 6

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

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

B. They cannot include the WHEN clause.

C. They must be created in an enabled state.

D. They must be created in a disabled state.

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

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

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

Correct Answer: A,F,G

Question 7

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

A. #printer_name

B. v_fname

C. 1to7number

D. Number_of_days_between_March_and_April

E. yesterday's_date

F. leap$year

G. printer_name#

Correct Answer: B,F,G

Welcome to TestSimulate

Oracle Database 19c: Program with PL/SQL (1Z0-149) Free Practice Test