SQL Transactions Flashcards

1
Q

BEGIN

A

Begins a transaction in the current session.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

COMMIT

A

Commits an open transaction in the current session.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ROLLBACK

A

Rolls back an open transaction in the current session.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

SHOW LOCKS

A

Lists all running transactions that have locks on resources.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

SHOW TRANSACTIONS

A

List all running transactions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly