Question

What is known as the set of SQL statements that either executes successfully or none of them have an effect?

(a) joins

(b) transactions

(c) filters

(d) deletions

This question was posed to me in class test.

I'm obligated to ask this question of Performing Transactions in chapter Using SQL to Manage Data of MySQL

Answer 1

The correct choice is (b) transactions

The explanation is: In MySQL, a transaction is a set of SQL statements that are run as a single unit. They can be canceled when required, but they can either execute successfully or neither of them executes.