How can a user test Transactions in an SQL database?

1.	How can a user test Transactions in an SQL database?
Answer» This requires the ACID properties, and to achieve that we use the following statements- Using the ROLLBACK command CHANGES are rolled back to the previous commit. Once transactions are EXECUTED, the user can use SELECT queries to VALIDATE the data. Example BEGIN TRANSACTION TRANSACTION# END TRANSACTION TRANSACTION# ROLLBACK TRANSACTION#

Answer»

This requires the ACID properties, and to achieve that we use the following statements-

Using the ROLLBACK command CHANGES are rolled back to the previous commit. Once transactions are EXECUTED, the user can use SELECT queries to VALIDATE the data.

Example

BEGIN TRANSACTION TRANSACTION#

END TRANSACTION TRANSACTION#

ROLLBACK TRANSACTION#

Discussion

No Comment Found

Related InterviewSolutions

How data integrity can be tested in database testing?
How can a user test Transactions in an SQL database?
How tables and columns can be validated in the database?
Write down the test scenarios for migration of database from one SQL server to another?
List some of the major challenges we faced while performing database testing?
If a user has more than 1000 lines of procedure, how will he/she test that where it is failing?
Can mentioned requirement be testable "A fast database retrieval rate"?
Does QTP support SQL Queries? If yes, how?
List out some different SQL statements that can be used for database testing?
What are the ways to validate if a database table has been updated after you enter data from a front-end application?

How can a user test Transactions in an SQL database?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment