Multiple choice

The following statement was issued: ALTER TABLESPACE users_data READ ONLY; Which of the following statements is not true?

  1. A checkpoint occurs for each data file associated with the USERS_DATA tablespace.

  2. The data files for the USERS_DATA tablespace will need to be recovered if they become corrupt or a media failure occurs.

  3. The control file is updated to identify the data files for the USERS_DATA tablespace as read-only during recovery.

  4. The checkpoint numbers in the data files for the USERS_DATA tablespace are frozen and do not need to be synchronized with the checkpoint number in the control file.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a tablespace is made read-only with ALTER TABLESPACE, Oracle performs a checkpoint and updates the control file to mark the data files as read-only for recovery purposes. This prevents the database from attempting to apply redo logs to these files during recovery. The checkpoint numbers in the data file headers are frozen at this point, so they don't need to stay synchronized with the control file's checkpoint number.

Keep practicing — related questions