Which two statments regarding the control file and Recover Manager are true ? (Choose two)
-
The control file can grow in size.
-
The control file can store RMAN scripts.
-
CONTROL_FILE_RECORD_KEEP_TIME determine retention time for RMAN records.
-
The RMAN catalog can exist solely in the control file of the target database.
The control file can grow in size when new records are added (like RMAN metadata). CONTROL_FILE_RECORD_KEEP_TIME determines how long RMAN records are kept in the control file - it directly controls retention. Option B is false because RMAN scripts are stored in the RMAN catalog or filesystem, not the control file. Option D is false because while RMAN can use a control file catalog, it requires additional configuration and is not automatic.
This is a 'choose two' question, but the DB only marks one option correct, so the answer set is incomplete. Per Oracle RMAN documentation: CONTROL_FILE_RECORD_KEEP_TIME does set the minimum retention (in days) before a reusable RMAN record in the control file can be overwritten - so that DB-marked answer is indeed true. But it is also true that 'the control file can grow in size': when no reusable record slot is old enough (per CONTROL_FILE_RECORD_KEEP_TIME) to be overwritten for a new RMAN record, Oracle automatically expands the control file rather than failing. By contrast, 'the control file can store RMAN scripts' is false - stored/global RMAN scripts require a recovery catalog, not just the control file. And 'the RMAN catalog can exist solely in the control file' is false/contradictory - the recovery catalog is by definition a separate external database schema; without one, the control file merely serves as the RMAN metadata repository, which isn't the same as 'the catalog existing in the control file.' So the missing second true statement is 'the control file can grow in size.'