The stream position is advanced when the stream is used in a DML statement, and the position is updated at the end of the transaction to the beginning timestamp of the transaction.

• A. True
• B. False
• C. It is updated to the end timestamp
• D. The position is updated to the beginning of the next transaction

Answer: (D)

Streams track changes up to the point you have consumed them. When you use a stream in a DML statement, the changes involved are considered consumed at the commit of that transaction. The stream’s position is then advanced to the beginning of the next transaction, which creates a clean boundary for future reads. This means on the next read you’ll only see changes from transactions that started after the one you just consumed. Moving the position to the end timestamp or to the start of the same transaction would not provide a proper boundary and could risk re-reading or missing data, whereas advancing to the next transaction’s start properly separates processed changes from new ones.