フリー問題

問題文

A session updates 40 rows without committing, then issues a CREATE TABLE statement, then issues a ROLLBACK. A colleague expects the 40 updated rows to go back to their old values. What is the state of those rows?

選択肢

1. The updates are undone, because the database keeps the open transaction separate from the data definition statement.
2. The updates are undone, because the database rolls the open transaction back before the data definition statement.
3. The updates stay uncommitted, because a data definition statement takes a separate transaction of its own.
4. The updates are permanent, because the database commits the open transaction before it runs a data definition statement.