Explain what a trigger is and what it does

What will be an ideal response?


A trigger is a procedure that is executed when data within a table is altered through adding, deleting, or changing of entities. Triggers are very similar to stored procedures, except that they are completely hidden. Since no user or no application can bypass triggers, they also provide an effective mechanism for ensuring data integrity.

Business

You might also like to view...

Briefly define risk propensity and explain how it influences negotiator behavior.

What will be an ideal response?

Business

The size of a fraud loss is strongly related to the position of the perpetrator, with owners and executives tending to commit less costly frauds

Indicate whether the statement is true or false

Business

Presentations to small groups

A) require more of a "you" attitude than talks to larger groups. B) increase the presenter's options for visual aids. C) require very emphatic gestures to oversell the key ideas. D) are delivered in a more formal tone than normal conversations. E) require time to understand any heterogeneous listeners.

Business

Check Collection. Robert Santoro was the manager of City Check Cashing, Inc, a check-cashing service in New Jersey, and Peggyann Slansky was the clerk. On July 14, Misir Koci presented Santoro with a $290,000 check signed by Melvin Green and drawn on

Manufacturers Hanover Trust Co (a bank). The check was stamped with a Manufacturers certification stamp. The date on the check had clearly been changed from August 8 to July 7. Slansky called the bank to verify the check and was told that the serial number "did not sound like one belonging to the bank." Slansky faxed the check to the bank with a query about the date, but received no reply. Slansky also called Green, who stated that the date on the check was altered before it was certified. Check Cashing cashed and deposited the check within two hours. The drawee bank found the check to be invalid and timely returned it unpaid. Check Cashing filed a suit in a New Jersey state court against Manufacturers and others, asserting that the bank should have responded to the fax before the midnight deadline in UCC 4-302 . Did the bank violate the midnight-deadline rule? Explain.

Business