Tuning PL/SQL Applications for Performance - questions and answers

Tuning PL/SQL Applications for Performance - questions and answers

1) In which binding operation a database value is assigned to a PL/SQL variable or a host variable by the RETURNING clause of an INSERT, UPDATE, or DELETE statement.

A) out-bind
B) in-bind
C) define
D) None of the above
View Answer / Hide Answer


2) The subprogram is called through a database link or as an external procedure.

A) True
B) False
View Answer / Hide Answer


3) Which datatypes make it practical to write PL/SQL programs to do number-crunching, for scientific applications involving floating-point calculations.

A) BINARY_FLOAT
B) BINARY_DOUBLE
C) Both A & B
D) None of the above
View Answer / Hide Answer


4) Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?

A) PLS_INTEGER
B) BINARY_INTEGER
C) Both A & B
D) None of the above
View Answer / Hide Answer


5) The values of any IN OUT parameters are copied before the subprogram is executed.

A) Yes
B) No
View Answer / Hide Answer