A. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
B. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
C. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
D. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
E. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
F. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
G. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
A. This program unit will compile successfully.
B. Initialization of loan_amount can be done while using this packaged variable in another program.
C. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
D. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
E. Initialization of min_bal can be done while using this packaged constant in another program.
F. This will not compile successfully because the min_bal constant must be initialized.
G. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
A. 15000
B. 5000
C. 2500
D. 10000
A. UPDATE
B. DROP
C. CREATE
D. SELECT
E. ALTER
F. DELETE
G. INSERT
A. a predefined PL/SQL-only data type like BOOLEAN
B. an associative array indexed by VARCHAR2
C. an associative array indexed by PLS_INTEGER
D. a record declared in a procedure
E. a record declared in a package specification
F. a record declared in an anonymous block
A. They can be used in CONNECT BY and START WITH clauses.
B. They can be executed as standalone commands.
C. They can appear in the select list of a SELECT statement.
D. Functions can call only other functions.
E. They need not return any values.
F. They must be defined with at least one parameter.
G. They can be used in ORDER BY and GROUP BY clauses.
A.
B.
C.
D.
