Page 83 of 95
Ans : C
53. Which of the following is not correct about User_Defined Exceptions
?
a] Must be declared
b] Must be raised explicitly
c] Raised automatically in response to an Oracle error
d] None of the above
Ans : C
54. 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
Ans : D
55. 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.
Ans : C
56. Is it possible to open a cursor which is in a Package in
another
procedure ?
a] Yes
b] No
Ans : A
57. Is it possible to use Transactional control statements in
Database
Triggers ?
a] Yes
b] No
Ans : B
58. Is it possible to Enable or Disable a Database trigger ?
a] Yes
b] No
|
|