is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.

Related MCQs

• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• A                      is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
• How inserting data through stored procedure do reduces network traffic and increase database performance?
• The database design that consists of multiple tables that are linked together through matching data stored in each table is called
• The database design that consists of multiple tables that are linked together through matching data stored in each table is called
• If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
• A Database Procedure is stored in the Database
• A Stored Procedure is a
• ……………….. contains information that defines valid values that are stored in a column or data type.
• The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?