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
• ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is
• ……………….. contains information that defines valid values that are stored in a column or data type.