Which of the following is not a transaction management SQL command?

2017

Which of the following is not a transaction management SQL command?

Answer: C. Select — COMMIT, ROLLBACK, SAVEPOINT are transaction control (TCL) commands. SELECT is a data retrieval (DQL) command, not transaction management.

  1. A.

    Rollback

  2. B.

    Commit

  3. C.

    Select

  4. D.

    Savepoint

Attempted by 309 students.

Show answer & explanation

Correct answer: C

COMMIT, ROLLBACK, SAVEPOINT are transaction control (TCL) commands.

SELECT is a data retrieval (DQL) command, not transaction management.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Niacl Ao It Specialist

Loading lesson…