In SQL, the "ROLLBACK" statement is used to ____________ a transaction and undo its changes.
- Commit
- Begin
- End
- Terminate
The correct option is "Commit." The ROLLBACK statement in SQL is used to cancel a transaction and undo any changes made since the start of the transaction. It's essential for maintaining data integrity in case of errors or other issues.
Loading...
Related Quiz
- In SQL, the SELECT statement is used to retrieve data from one or more ____________.
- In role-based access control (RBAC), permissions are assigned to ____________ rather than individual users.
- Scenario: In a database testing project, you encounter challenges related to data consistency and accuracy. What actions should be taken to address these challenges?
- When dealing with sensitive data, test data generation tools should provide _________ features to mask or anonymize sensitive information.
- Database security is essential for protecting sensitive data from unauthorized ____________.