Multiple choice technology databases

Which two statements about the Transient Journal are true?

  1. It permits successful rollback to the last archive

  2. After the transaction is committed, the Before Images are discarded

  3. Transient Journal operation is automatic

  4. Before Images are kept until manually purged
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

The Transient Journal in Teradata maintains before-images of rows during transactions. After commit, these before-images are automatically discarded (B is true). The journal operation itself is automatic and requires no manual intervention (C is true). A is false because rollback uses the transient journal, not archives. D is false because before-images are discarded automatically after commit.

Keep practicing — related questions