procedure to create a customized ERROR message
RAISE_ERROR
SQLERRM
RAISE_APPLICATION_ERROR
RAISE_SERVER_ERROR
Which of the following is false statement of the package.
Dependency simplified
Loaded once into memory , used subsequently
Privileges to objects cannot be controlled
Encapsulation of code logic
The keyword return is compulsory in
Procedure definition
Function definition
both A & B
Option in both A & B
Examine this database trigger CREATE OR REPLACE TRIGGER prevent_gross_modification {additional trigger information} BEGIN IF TO_CHAR(sysdate, DY) = MON THEN RAISE_APPLICATION_ERROR(-19999,'user Defined error'); END IF; END; This trigger will error out
True
False
_________ is the maximum nuber of Exceptions that the PL/SQL engine will process before exiting out of the BLOCK.
only one
All that apply
I Dont know
None of the above
A procedure can have a procedure declaration inside
Multiload will not support
USI
NUSI
Both a and b
Neither a nor b
In Teradata, indexes are maintained by the Senior Database Administrator
Secondary Index is used for
Access the rows
Distribution of the rows
Only for distribution of rows to particular AMPs
Primary Index is mandatory for teradata table