C# Mastery Hub
Home
Challenges
Discussion
Lessons
Core Topics
C# Fundamentals
Console Applications
Classes & OOP
Windows Forms
ASP.NET Core
SQL Server
VS & SQL Connection
RDLC Reports
.NET MAUI
Getting Started
Getting Started
Website Development
SEO Guide
Security
Project Workflow
Extra Topics
Cloud & Deployment
AWS Cloud
Deployment
About
Contact
Test Your Knowledge
SQL Server - Lesson 10: Transactions Quiz
Answer all questions to test your understanding
1
What is a transaction?
A group of statements that all succeed or fail together
A single statement
A type of index
A view
2
What does COMMIT do?
Saves the transaction permanently
Undoes the transaction
Cancels the transaction
Pauses the transaction
3
What does ROLLBACK do?
Undoes all changes in the transaction
Saves the transaction
Pauses the transaction
Starts a new transaction
4
What does the 'A' in ACID stand for?
Atomicity
Availability
Accuracy
Authenticity
5
What does the 'D' in ACID stand for?
Durability
Data
Database
Default
6
What should you use to handle errors in a transaction?
TRY-CATCH with ROLLBACK
Ignore errors
COMMIT on error
DELETE on error
Submit Quiz