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: 1 / 2
Total 65 questions

Which three are true about PL/SQL subprograms? (Choose three.)

A.

Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.

B.

Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.

C.

Subprograms are cached by default and shared among users, thereby reducing memory requirements.

D.

Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.

E.

A subprogram's session state is retained even if any of the session’s instantiated subprograms are invalidated and revalidated.

F.

Host variables can be referenced inside any PL/SQL subprogram.

G.

A PL/SQL procedure can invoke an external code block written in a different programming language.

Which three are true about functions and procedures? (Choose three.)

A.

The ACCESSIBLE BY clause can be used only for procedures.

B.

In a function, every execution path must lead to a RETURN statement.

C.

Both can have only constants as actual parameters for IN mode parameters.

D.

Both can be invoked from within SQL statements.

E.

In a procedure the RETURN statement cannot specify an expression.

F.

In a function every RETURN statement must specify an expression.

Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

A.

a record declared in an anonymous block

B.

a record declared in a procedure

C.

an associative array indexed by PLS_INTEGER

D.

a record declared in a package specification

E.

a predefined PL/SQL-only data type like BOOLEAN

F.

an associative array indexed by VARCHAR2

Which three are true about user-defined functions? (Choose three.)

A.

They can be used in ORDER BY and GROUP BY clauses.

B.

They can be executed as standalone commands.

C.

They must be defined with at least one parameter.

D.

They need not return any values.

E.

They can appear in the select list of a SELECT statement.

F.

Functions can call only other functions.

G.

They can be used in CONNECT BY and START WITH clauses.

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

A.

Implicit cursor returns only one record.

B.

Explicit cursor can return more than one record.

C.

%Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

D.

%Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

E.

%Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

F.

%Isopen is always false in Explicit Cursor.

G.

%Isopen is always false in Implicit Cursor.

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

A.

DISABLE

B.

ENABLE

C.

ERROR

D.

ALL

E.

SEVERE

Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

A.

It can be used in the declaration of object types.

B.

It must be specified in the heading of a package specification.

C.

The check is enforced by this clause for direct access and access through dynamic SQL.

D.

It can be used for individual procedures and functions declared in a package specification.

E.

It must be specified in the heading of a package body.

Examine these statements:

Which is true?

A.

It will result in a compilation error for protected_proc because calling_proc does not exist.

B.

It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

C.

It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

D.

With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

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

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.

Which is the correct method to implement a local subprogram in an anonymous block?

A.

B.

C.

D.