Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

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

Page: 2 / 2
Total 65 questions

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

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.

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

A.

B.

C.

D.

Which two blocks of code display a numerical zero? (Choose two.)

A.

B.

C.

D.

Which is true about EXIT and CONTINUE statements?

A.

They can be used in any type of loop.

B.

They must have a WHEN condition.

C.

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

D.

They must use labels.

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

A.

DDL

B.

AFTER AUDIT

C.

BEFORE ANALYZE

D.

SHUTDOWN

E.

SERVERERROR

F.

STARTUP

G.

BEFORE GRANT

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

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.

Examine this statement which executes successfully:

SQL> SET SERVEROUTPUT ON;

Now, examine this code which is executed:

What is true about the result?

A.

It returns an error in line 2.

B.

It returns an error in line 4.

C.

It returns an error in line 9.

D.

It executes and displays output.

Sequence S and table PRODUCTS exist in your schema.

Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

A.

line 1

B.

line 6

C.

line 8

D.

line 2

E.

line 3

F.

line 7

The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).

Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

A.

B.

C.

D.

E.