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.

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.
•                          is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.
• ……………… table store information about database or about the system.
• 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
• The                      requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
• The                          scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
• Drop Table cannot be used to drop a table referenced by a …………… constraint.
• A table can be logically connected to another table by defining a