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

Discuss the differences between triggers and stored procedures.

How do triggers differ from stored procedures in a database?

When do triggers happen, and what are they? I'm confused as to what role they play. In Access 2016, how can you mimic a trigger's actions?

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