module 8 part #1

Question 1

a piece of SQL code that is invoked when an event occurs. such as an insert, update, or delete statement

Answer 1

trigger

Question 2

What type of integrity is enforced when a primary key is declared?

Answer 2

entity integrity

Question 3

What is a stored procedure, and why is it particularly useful? Give an example.

Answer 3

A stored procedure is kind of like a function in code. It can be saved and used over and over again.

Question 4

adds data to the table

Answer 4

INSERT

Question 5

applies to data that is ALREADY in the table.

Answer 5

UPDATE

Question 6

can be used to make changes to an existing table, such as adding, dropping, or modifying a column

Answer 6

ALTER command

Question 7

used to validate data when an attribute value is entered.

Answer 7

CHECK constraint