Select the correct answerWhat one is not a Transaction Control Statement?OptionsCommitSavepointCommitSet transactionRollback

To identify which option is not a Transaction Control Statement (TCS), let's briefly analyze each option:

1. Commit: This statement is used to save all the changes made during the current transaction to the database. It is a valid TCS.

2. Savepoint: This statement allows you to set a point within a transaction to which you can later roll back. It is a valid TCS.

3. Set transaction: This statement is used to specify characteristics for the transaction, such as its isolation level. However, it is not typically classified as a standard Transaction Control Statement like Commit or Rollback.

4. Rollback: This statement is used to undo changes made in the transaction until a specified savepoint or the beginning of the transaction. It is a valid TCS.

Final Answer

The correct answer is Set transaction, as it is not considered a standard Transaction Control Statement in most contexts.