Question

Which of the following statement is false ?

(a) Any procedure can raise a error and return an user message and error number

(b) Error number is 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

This question was posed to me in final exam.

The doubt is from Programmatic Oracle Structures in section Oracle Database 11g Architecture Options of Oracle

Answer 1

The correct choice is (c) Oracle checks Uniqueness of User defined errors

To elaborate: The UNIQUE constraint uniquely identifies each record in a database table.The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns.