SQL Quiz: What is a SQL transaction?

Task 168:

Select all correct facts about SQL transaction from the options below:

A SQL transaction is a logical unit of work that is performed as a single atomic operation. It ensures that either all changes within the transaction are committed to the database or none of them are. This maintains data integrity and consistency.

A SQL transaction is a sequence of SQL statements that are treated as a single unit. If any statement within the transaction fails, the entire transaction will be rolled back, undoing all changes made.

A SQL transaction is similar to a function call in programming, where it takes input, performs operations, and returns output.

A SQL transaction is a type of network protocol used for communication between databases.

A SQL transaction is a command that is executed directly on a database server.

A SQL transaction is a specific type of SQL statement that is used to perform calculations on data.

A SQL transaction is a type of SQL query used for data retrieval.

Mark all correct answers and click the "Check!" button

Login

Register