Multiple Choice
In PL/SQL,a function is used instead of a procedure when:
A) You want to manipulate output variables.
B) You want to produce a side effect.
C) You are returning a single value.
D) You want to return more than one result.
Correct Answer:

Verified
Correct Answer:
Verified
Q21: The common SQL*Plus command used to display
Q22: A database connection identifies the database used
Q23: Like procedures,triggers can be tested directly by
Q24: In a stored procedure,a(n)_ parameter should have
Q25: For statement level interfaces,SQL:2003 provides statements to:<br>A)
Q27: To catch a specific error in a
Q28: In the SQL:2003 specification,a statement level interface
Q29: Transitive closure,an important operation for queries involving
Q30: In PL/SQL,a(n)_ statement is comprised of a
Q31: The two language styles provided by SQL:2003