Which of the following are valid table-partitioning methods?
Range
Freelist
Hash
Index
INTERVAL PARTITIONING IS NOT SUPPORTED FOR INDEX-ORGANIZED TABLES.
True
False
CAN WE SPECIFY MULITPLE PARTITIONING KEY COLUMNS IN INTERVAL PARTITIONING TECHNIQUE
CAN WE SPECIFY VARCHAR DATATYPE FOR THE PARTITIONING KEY IN INTERVAL PARTITIONING TECHNIQUE
IS IT POSSIBLE TO SPECIFY THE EXECUTION ORDER OF TRIGGERS IN ORACLE 10G
CAN SIMPLE_INTEGERS CONTAIN NULL VALUES
REGEXP_COUNT TAKES STRING AND REGULAR EXPRESSION AND RETURNS NUMBER OF TIMES THE EXPRESSION IS PRESENT IN THE STRING
INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE BASED ON
HASH
MODULUS
RANGE
RANDOM
Need to create a trigger on the EMP table that monitors every row that is changed and place this info into the AUDIT_TABLE What type of Trigger to be used ?
FOR EACH ROW trigger on the EMP table
Statement-level Trigger on the EMP table
FOR EACH ROW trigger on the AUDIT_TABLE table
Statement-level Trigger on the AUDIT_TABLE
what part of DB trigger determines the number of times the trigger body executes ?
Trigger type
Trigger body
Trigger event
Trigger Timing