Oracle Business Process Management Suite 12c Essentials
Oracle Hyperion Financial Management 11 Essentials
Oracle SOA Suite 12c Essentials
Oracle WebLogic Server 12c Essentials
Java SE 8 Programmer II
Oracle Business Intelligence Foundation Suite 11g Essentials
Siebel 8 Consultant
Oracle WebLogic Server 12c: Administration I
Oracle VM 3 for x86 Essentials
Oracle Database 12c Essentials
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.
Which three are valid PL/SQL variable names? (Choose three.)
printer_name#
1to7number
yesterday's_date
leap$year
Number_of_days_between_March_and_April
#printer_name
v_fname
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.