Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
22 Cards in this Set
- Front
- Back
How can web applications implement transactions?
|
By using methods that initiate transaction. (3)
|
|
What are the three methods that web applications implement transactions
|
1, initiate the transaction 2. commit the transaction 3. revert the transaction back to the original state |
|
What are the formal statements of implementing web applications.
|
1. BEGIN TRANSACTION 2.COMMIT 3.ROLLBACK |
|
What are some real world examples using and implementing transactions
|
1. Banking information and when the power goes out.
|
|
If a system fails, what needs to have functions and features to handle the process
|
. The database and the system
|
|
What are three functions in .NET that can be used in a transaction?
|
1. BeginTrans 2. CommitTrans 3. RollbackTrans |
|
What does BeginTrans do? CommitTrans RollbackTrans |
1. BeginTrans- Starts a new transaction. 2. CommitTrans saves changes and completes transaction. 3. RollbackTrans cancels and changes during the current transaction and ends the transaction |
|
What is the most common way to implement transactions?
|
1. Through Query Statements handled by the Data Base
|
|
What does the W3C RDF protocol state?
|
In a transaction, all process are performed by temporary states. (The are not seen by the clients until commited
|
|
Because the information is not seen by the Client and is in a temporary state you can _________________ the transaction
|
Rollback
|
|
What are other ways to implement transaction recall?
|
Triggers are a great way to implement transaction recall
|
|
What are triggers? What do they do?
|
Triggers are events the occur in the database that cause and action to occur.
|
|
What is an example of a trigger
|
1. Save record plus User ID and DateTime to another table. |
|
How do you implement a trigger?
|
1. Run code as a query in a database once. (After that a trigger will exist.)
|
|
what is an example of a trigger |
CREATE TRIGGER ON FORAS
|
|
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.
|
CREATE TRIGGER trgInsert ON tblPerson FOR INSERT AS INSERT INTO tblLog(USERNAME, FName, LName, Address, City, State, Zip, Now()) VALUES(USERNAME, 'Dan', 'Parrell', '920 Cross Street', 'Oxford', 'Michigan', '48371') |
|
Final way to manage transactions is?
|
Implement and used the database transaction log file.
|
|
In Microsoft SQL , how are the logs stored
|
1. In the order they are created
|
|
How are the server logs stored.
|
In the order they were created.
|
|
What will link the log record back to the transaction
|
the record identifier.
|
|
A database represents the __________________ of the database at a point in time
|
ans. State
|
|
Any changes to the database since the backup are stored?
|
Transaction log
|