If the Values in an SQL View Are Not Changeable

question 100

Multiple Choice

If the values in an SQL view are not changeable through the view itself,you may still be able to update the view by using unique application logic.In this case,the specific logic is placed in ________.

• A)a BEFORE trigger
• B)an INSTEAD OF trigger
• C)an AFTER trigger
• D)Depending on the specific logic,either A or B can be used.
• E)Depending on the specific logic,any of A,B,or C can be used.

---

Definitions:

Function

A relation between a set of inputs and a set of permissible outputs, often defined by an equation.

Inverse Function

A mathematical function that reverses the effect of another function, such that if the function f applied to an input x gives a result of y, then applying its inverse function to y gives the result x.

Function

An interrelation between a variety of inputs and a catalog of admissible outputs, with the requirement that every input is pinpointed to a unique output.

Composition

The process of combining two functions by applying one function to the result of another, typically notated as (f◦g)(x).