PL SQL Blocks

PL SQL Blocks Answer

1.What is the clause we need to add in function body to return variable?
Answer: Return varchar2


2.What is the clause we need to add in function header to return variable?
Answer: Return varchar2

3.Function can be used in select statments only if function not having any dml operation?
Answer: True

4.Which of the folling is the examples of named book?
Answer: All of the above

5.Function can return more than one value.
answer: False.

6.Cursor should be declared in begin block in pl/sql
Answer: False.

7.Which of the folling is not a cursor attribute?
Answer: None of the above

8.what is the exit condition we should include in pl\sql block to terminate the loop?
Answer: exit when SQL%NOTFOUND.

9.   .......... is the pointer to context are  which is used to process the sql result set in pl\sql?
answer Cursor
10.  In pl\sql, you can refer to the most recent implicit cursor as sql cursor
Answer: True