Multiple choice

An Oracle System Change Number (SCN) _______.

  1. is a value that is incremented whenever a dirty read occurs

  2. is incremented whenever a deadlock occurs

  3. is a value that keeps track of explicit locks

  4. is a value that is incremented whenever database changes are made
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle SCN (System Change Number) is a logical timestamp that increments whenever database changes are made. It's used for data consistency, recovery, and tracking the order of transactions. It is NOT related to dirty reads, deadlocks, or explicit locks.

Keep practicing — related questions