Stored Routines & Triggers

A Stored Procedure is a

• Sequence of SQL statements to perform specific function

• Stored in (pre-)compiled form in the database

• Can be called from all client environments

• All the above

What are the benefits of Stored Procedures?

• Reduced Traffic

• Easy Maintenance

• Reusability & Stronger Security

• All of the above

What is the primary purpose of using triggers in a database?

• To improve performance

• All of the above

• To enhance security

• To automate tasks

Which of the following is a characteristic of a function in SQL?

• Can return a value

• All of the above

• Cannot modify database state

• Can be used in SQL expressions

What are the three parameter modes for procedures?

• IN, OUT, INOUT

• Read, Write, Append

• CONSTANT, VARIABLE, DEFAULT

• COPY, NO COPY, REF

An SQL trigger provides the ability to _____ and _____ (to) data change events.

(CHOOSE TWO OPTIONS)

• Ignore, Delete

• Log, Audit

• Recognize, React

• None of these. SQL triggers are not related to external events.

Can a COMMIT statement be executed as a part of trigger?

• Yes.

• No.