When using the "BEGIN TRANSACTION" statement, you must also include a corresponding ____________ statement.
- BEGIN
- COMMIT
- ROLLBACK
- SAVEPOINT
The correct option is "ROLLBACK." When starting a transaction with BEGIN TRANSACTION, it must be followed by a corresponding ROLLBACK statement to undo the changes made within the transaction if necessary.
Loading...
Related Quiz
- A common encryption method used in database security is ____________ encryption, which protects data at rest.
- What role does database version control play in the testing process?
- Data encryption helps protect sensitive information from unauthorized access by converting it into an unreadable format using ____________ algorithms.
- What is the significance of referential integrity constraints in data consistency testing?
- In a SQL query with multiple JOINs, what is the significance of the join order?