Machine-translated by Google. Questions are authored in English.
Top

Discussion

An Oracle System Change Number (SCN):

  • A.is a value that is incremented whenever a dirty read occurs.
  • B.is incremented whenever a deadlock occurs.
  • C.is a value that keeps track of explicit locks.
  • D.is a value that is incremented whenever database changes are made.

Answer: D

Correct answer: is a value that is incremented whenever database changes are made.

The system change number is a database-wide counter advanced whenever a change is committed, and it stamps every change in the redo stream and every datafile header. It is what allows Oracle to establish the ordering of changes, to determine whether a set of files is consistent, and to recover to a chosen point in time.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.