databases Online Quiz - 103
Description: databases Online Quiz - 103 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
The keyword return is compulsory in
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
_________ is the maximum nuber of Exceptions that the PL/SQL engine will process before exiting out of the BLOCK.
A procedure can have a procedure declaration inside
Multiload will not support
In Teradata, indexes are maintained by the Senior Database Administrator
Secondary Index is used for
Primary Index is mandatory for teradata table
Primary Index is used for
Fastload will not support
Primary index value can be changed
Reading the rows using Non-Unique Secondary index is
For PPI table, rows are first sorted by ------ at each AMPs
Reading the rows using Non-Unique Primary index is one AMP operation
Teradata table will have ------ Primary Index
Reading the rows using Unique Secondary index is
Views can be specified in a trigger statement
Two functions can be used with the same name in a PL/SQL block
What is the maximum number of statements that can be specified in a trigger statement?
Which of the following is not a schema object?