Oracle Oracle Database PL/SQL Developer Certified Professional 1z0-149 New Questions

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

Question 5

Which statement is true about user-defined records?

They can be returned from a function.

Field types must match column types.

The number of fields must match the number of columns in a table.

Field names must match selected column names.

Question 6

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

It can be used in the declaration of object types.

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

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

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

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

Question 7

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

The ACCESSIBLE BY clause can be used only for procedures.

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

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

Both can be invoked from within SQL statements.

In a procedure the RETURN statement cannot specify an expression.

In a function every RETURN statement must specify an expression.

Question 8

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