Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Chapter 14

memorize.ai (lvl 286)

(0)

13 cards

()

Section 1

Preview this deck

Roll back a transaction

Front

1 / 13

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (13)

Section 1

(13 cards)

Roll back a transaction

Front

What command do you give to transactions when you want to reverse your transactions?

Back

Nonrepeatable Read

Front

What occurs when two SELECT state that try to get the same data get different values because another transaction has updated the data in the time between the two statements?

Back

Transaction

Front

What when you group statements into logical unit of work?

Back

Dirty Read

Front

What occurs when a transaction selects data that hasn't been committed by another transaction ?

Back

Phatom Read

Front

What occurs when you perform an update or delete on a set of rows at the same time that another transaction is performing an insert or delete that affects one or more rows in the same set of rows?

Back

Concurrency

Front

What has the ability of a system to support two or more transactions working with the same data at the same time?

Back

Transaction isolation level

Front

What controls the degree to which transactions are isolated from one another?

Back

Commit a transaction

Front

What command do you give to make changes in a transaction ?

Back

Lost Update

Front

What is a problem that you've already read about? Which occurs when two transactions select the same row and then update the row based on the values originally selected?

Back

Save Point

Front

What is used to identify points within a transaction?

Back

Deadlock

Front

What occurs when neither of two transactions can be committed because each transaction has a lock on a resource needed by the other transaction?

Back

Locking, Using Locks

Front

What can automatically prevent some concurrency problems? and or A transaction not yet committed?

Back

Deadlock Victim

Front

What is harmed by this action?

Back