Trigger: In a database , a trigger is a program joined to a particular table or view. It will executed by the DBMS (Database Management System), when certain events may occur using that table. It can be executed before or after the “SQL” commands which use the “INSERT”, “UPDATE” or “DELETE” operations or once for each modified row. If a trigger event has occurs, the trigger’s function will called at the time of handling the event. These events are handled using “BEFORE”, “AFTER” or “INSTEAD OF” trigger logics.

Question

Want to see the full answer?

Answer 1

Question

Chapter 7, Problem 7.5RQ

Program Plan Intro

Trigger:

In a database, a trigger is a program joined to a particular table or view. It will executed by the DBMS (Database Management System), when certain events may occur using that table.

It can be executed before or after the “SQL” commands which use the “INSERT”, “UPDATE” or “DELETE” operations or once for each modified row.

If a trigger event has occurs, the trigger’s function will called at the time of handling the event.

These events are handled using “BEFORE”, “AFTER” or “INSTEAD OF” trigger logics.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

The activation of one trigger may cause the activation of another. True False

The activation of one trigger may result in the activation of another trigger. True False

differences between Trigger and Stored Procedures in tabular form

Answer 2

Question

Chapter 7, Problem 7.5RQ

Program Plan Intro

Trigger:

In a database, a trigger is a program joined to a particular table or view. It will executed by the DBMS (Database Management System), when certain events may occur using that table.

It can be executed before or after the “SQL” commands which use the “INSERT”, “UPDATE” or “DELETE” operations or once for each modified row.

If a trigger event has occurs, the trigger’s function will called at the time of handling the event.

These events are handled using “BEFORE”, “AFTER” or “INSTEAD OF” trigger logics.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 7, Problem 7.5RQ

Program Plan Intro

Trigger:

In a database, a trigger is a program joined to a particular table or view. It will executed by the DBMS (Database Management System), when certain events may occur using that table.

It can be executed before or after the “SQL” commands which use the “INSERT”, “UPDATE” or “DELETE” operations or once for each modified row.

If a trigger event has occurs, the trigger’s function will called at the time of handling the event.

These events are handled using “BEFORE”, “AFTER” or “INSTEAD OF” trigger logics.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 7, Problem 7.5RQ

Program Plan Intro

Trigger:

In a database, a trigger is a program joined to a particular table or view. It will executed by the DBMS (Database Management System), when certain events may occur using that table.

It can be executed before or after the “SQL” commands which use the “INSERT”, “UPDATE” or “DELETE” operations or once for each modified row.

If a trigger event has occurs, the trigger’s function will called at the time of handling the event.

These events are handled using “BEFORE”, “AFTER” or “INSTEAD OF” trigger logics.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 7, Problem 7.5RQ

Program Plan Intro

Trigger:

In a database, a trigger is a program joined to a particular table or view. It will executed by the DBMS (Database Management System), when certain events may occur using that table.

It can be executed before or after the “SQL” commands which use the “INSERT”, “UPDATE” or “DELETE” operations or once for each modified row.

If a trigger event has occurs, the trigger’s function will called at the time of handling the event.

These events are handled using “BEFORE”, “AFTER” or “INSTEAD OF” trigger logics.

Answer 6

Chapter 7, Problem 7.5RQ

Program Plan Intro

Trigger:

In a database, a trigger is a program joined to a particular table or view. It will executed by the DBMS (Database Management System), when certain events may occur using that table.

It can be executed before or after the “SQL” commands which use the “INSERT”, “UPDATE” or “DELETE” operations or once for each modified row.

If a trigger event has occurs, the trigger’s function will called at the time of handling the event.

These events are handled using “BEFORE”, “AFTER” or “INSTEAD OF” trigger logics.

Answer 7

Chapter 7, Problem 7.5RQ

Program Plan Intro

Trigger:

In a database, a trigger is a program joined to a particular table or view. It will executed by the DBMS (Database Management System), when certain events may occur using that table.

It can be executed before or after the “SQL” commands which use the “INSERT”, “UPDATE” or “DELETE” operations or once for each modified row.

If a trigger event has occurs, the trigger’s function will called at the time of handling the event.

These events are handled using “BEFORE”, “AFTER” or “INSTEAD OF” trigger logics.

Answer 8

Expert Solution & Answer

Answer 9

Expert Solution & Answer

Answer 10

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 11

Ch. 7 - Prob. 7.1RQ Ch. 7 - Prob. 7.2RQ Ch. 7 - Prob. 7.3RQ Ch. 7 - Prob. 7.4RQ Ch. 7 - Prob. 7.5RQ Ch. 7 - Prob. 7.6RQ Ch. 7 - Prob. 7.7RQ Ch. 7 - Prob. 7.8RQ Ch. 7 - Prob. 7.9RQ Ch. 7 - Prob. 7.10RQ

Solution Summary: The author explains the three types of triggers: BEFORE, AFTER, and INSTEAD OF.

Concept explainers

Want to see the full answer?

Chapter 7 Solutions