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

examout.co

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 is the correct method to implement a local subprogram in an anonymous block?

A.

B.

C.

D.

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

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

Which block of code displays the error message “Incorrect price value”?

A.

B.

C.

D.

Which is true about the PLSCOPE_SETTINGS parameter?

A.

It is deprecated in Oracle 12c.

B.

It can be used to obtain information about all identifiers when compiling a procedure.

C.

It can be used to control execution of specific portions of the PL/SQL code conditionally.

D.

It can be used to control a user's privileges on PL/SQL objects at run time.

Which two are true about collections and RECORD types? (Choose two.)

A.

A variable of RECORD type can contain fields of another RECORD type or any collection type.

B.

Only associative arrays and nested tables can have elements of RECORD type.

C.

All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

D.

Collections and RECORD types are always dense.

E.

All collections and RECORD types can be stored in table columns.

F.

VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

A.

B.

C.

D.

Which is true about counter variables in a FOR loop?

A.

It must explicitly be declared.

B.

It can be modified in the body of the loop.

C.

It cannot be NULL.

D.

It is accessible outside the body of the loop.

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

A.

The actual parameters must be specified in the same order as the formal parameters are declared.

B.

Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.

C.

Only trailing optional parameters can be omitted in the invocation call.

D.

The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

E.

Any optional parameters can be omitted in the invocation call.