Cis 407 Study Questions Lesson

Front 1

Web applications can implement transactions by using methods that do three things?

Back 1

(a) initiate a transaction, (b) commit the transaction, or (c) revert the transaction back to the original state of the database.

Front 2

In many database languages, the formal statements are?

Back 2

BEGIN TRANSACTION, COMMIT, or ROLLBACK.

Front 3

In MS Access , the statements are ?

Back 3

AcceptChanges() or RejectChanges() of a Dataset.

Front 4

e following are the three functions in .NET that can be used in a transaction:

Back 4

BeginTrans starts a new transaction.CommitTrans saves changes and completes the current transaction.RollbackTrans cancels any changes during the current transaction and ends the transaction.

Front 5

What are triggers?

Back 5

Triggers are merely events that occur on the database that, when invoked, cause an action to occur, such as "Save the record plus UserID and DateTime to another table."

Front 6

How do you implement a trigger?

Back 6

To implement a trigger, run the code as a query in the database only once. From then on, the trigger will exist. An example of a trigger implemented on a database is as follows:

Front 7

Here is an example of the use of a trigger to save the entire tblPerson record into a tblLog table along with the UserID and DateTime of the transaction when the record is updated.

Back 7

CREATE TRIGGER trgInsertON tblPersonFOR INSERTASINSERT INTO tblLog(USERNAME, FName, LName, Address, City, State, Zip, Now())VALUES(USERNAME, 'Dan', 'Parrell', '920 Cross Street', 'Oxford', 'Michigan', '48371')

Front 8

What is the final way to manage the transactions

Back 8

A final way to manage transactions is to implement and use the database's transaction log file.