"Triggers and Stored Procedures", homework help

User Generated

xhxhgv

Computer Science

Description

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

1
RUNNING HEAD: COMPUTER SCIENCE.

DATA MANIPULATION LANGUAGE AND DATA DEFINITION LANGUAGE.
Introduction
Triggers are programmed to perform when a DML event occurs in the database server. Triggers
automatically perform a task when some type of SQL Server action occurs. As its name suggests, a trigger is
triggered by some monitored action. The monitored actions are categorized into three categories namely
1. DML (Data Manipulation Language) -Its trigger executes when an Insert, Update or Delete statement
is performed.
2.

DDL. (Data Definition Language) - activated by a schema level event such as creating a table or
altering an index.

3. Login command.
Data M...


Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags