MCQ: Procedures

A Stored Procedure is a
A. Sequence of SQL or PL/SQL statements to perform specific function
B. Stored in compiled form in the database
C. Can be called from all client environmets
D. All of the above
Answer: D

Which of the following statement is false
A. Any procedure can raise an error and return an user message and error number
B. Error number ranging from 20000 to 20999 are reserved for user defined messages
C. Oracle checks Uniqueness of User defined errors
D. Raise_Application_error is used for raising an user defined error.
Answer: C

Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a ( Select count(*) from Emp E2 where E1.SAL > E2.SAL ) will retrieve
A. 3500,5000,2500
B. 5000,2850
C. 2850,5750
D. 5000,5750
Answer: A

The default parameter type in stored procedures is
(a) IN
(b) OUT
(c) INOUT
(d) There is no default type
Answer: A

Declare fvar number := null; svar number := 5 Begin goto > if fvar is null then > svar := svar + 5 end if; End; What will be the value of svar after the execution ?
A. Error
B. 10
C. 5
D. None of the above
Answer: A