PL/SQL - Which two statements are true?A. A function must return a value.B. A procedure must return a value.C

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 204 of 241

Which two statements are true?

A. A function must return a value.
B. A procedure must return a value.
C. A function executes a PL/SQL statement.
D. A function is invoked as part of an expression.
E. A procedure must have a return Data

Total Answers and Comments: 5

Last Update: November 21, 2008 Asked by: Ramanjaneyulu

Sponsored Links

Best Rated Answer

—

Submitted by: krishnaindia2007

A. A function must return a value.
D. A function is invoked as part of an expression

A and D are true

Above answer was rated as good by the following members:
sourena_1237

November 26, 2007 00:57:15

Donram

RE: Which two statements are true?A. A fun...

A. A function must return a value

- It's True . " A function has to return a value "
-------------------------------------------------------------------
B. A procedure must return a value

- It's fase. " A Procedure may or may not return a value "
-----------------------------------------------------------------------------------
C. A function executes a PL/SQL statement

-It's True. We can write Data Manipulation Statements such as insert update delete inside the Function.
----------------------------------------------------------------------------------------------------
D. A function is invoked as part of an expression.

-It's True. We can invoke a function as a part of expression in sql statements.

-------------------------------------------------------------------------------------------------

E. A procedure must have a return Data

--It's false. No need ...

Is this answer useful? Yes | No

May 03, 2008 06:03:25

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: Which two statements are true?A. A function must return a value.B. A procedure must return a value.C. A function executes a PL/SQL statement.D. A function is invoked as part of an expression.E. A procedure must have a return Data

A. A function must return a value.
D. A function is invoked as part of an expression

A and D are true

Is this answer useful? Yes | No

1 0