How new and old values are made available to a trigger

Assignment Help Basic Computer Science

Reference no: EM131218944

a. What is a trigger?

b. What is the relationship between a trigger and a table or view?

c. Name nine possible trigger types.

d. Explain, in general terms, how new and old values are made available to a trigger.

e. Describe four uses for triggers.

Reference no: EM131218944

Questions Cloud

Create a view of computer named computer view : Create a view of COMPUTER named Computer View that displays Serial Number together with Make and Model as one attribute named Computer Type. Place a colon and a space between Make and Model in the format: Dell: OptiPlex 980. Run this statement, an..

How to use a trigger to accomplish such a deletion : Assume that the View Ridge Gallery will allow a row to be deleted from WORK if the work has never been sold. Explain, in general terms, how to use a trigger to accomplish such a deletion.

What are the emerging trends in logistics today : How the parties in the supply chain are able to share the up-to-date information about the market demand, develop the quality of operations and improve profitability with each other?

Design emphasis on type expressiveness and introduction : Design emphasis on type, expressiveness and introduction to identity. This project looks at language in its connotative and denotative forms and appropriates them into a visual metaphor.

How new and old values are made available to a trigger : What is the relationship between a trigger and a table or view?

What action on the view is definitely not allowed : Describe the SQL/PSM component of the SQL standard. What are PL/SQL and T-SQL? What is the MySQL equivalent?

Evaluation of macroeconomics performance of australia : BUS700 Economics Assignment. Purpose: To allow students to research and critically analyse an evaluate the macroeconomic performance of an economy. Topic: Analysis and evaluation of Macroeconomics performance of Australia and USA

What role do the actor and director have in the achievement : How effective is this particular production at accomplishing the playwright's goal? What role do the actors and director have in this achievement?

How views can be used to improve data security : Describe how views are used to provide an alias for tables. Why is this useful?

User Account

All Pages