RelationalDBDesign

SiteMap

Backup Recovery «Prev Next»

Oracle 26ai Fast-Start Fault Recovery - Quiz

Five questions, one point each. Select exactly three answers for question 1 and one answer for each remaining question. Question 1 earns credit only for the complete correct set with no extra choices; there is no partial credit.

1.	Which THREE mechanisms are the Fast-Start Fault Recovery components covered in this module? Select exactly three answers.
	A.	Automatic export of every changed table.
	B.	Fast-Start parallel rollback.
	C.	Fast-Start on-demand rollback.
	D.	Fast-Start checkpointing.

2.	Which statement correctly describes the benefits and limits of Fast-Start Fault Recovery? Select one answer.
	A.	Checkpointing can reduce crash-recovery work, while on-demand and parallel rollback can improve transaction recovery and data availability.
	B.	A configured recovery target guarantees the maximum application outage.
	C.	On-demand rollback replicates committed transactions to a standby.
	D.	Parallel rollback replaces backups after a storage failure.

3.	How does on-demand rollback differ from parallel rollback? Select one answer.
	A.	On-demand rollback starts only after a user issues ROLLBACK; parallel rollback requires an export.
	B.	On-demand rollback is exclusive to RAC; parallel rollback copies data between sites.
	C.	On-demand rollback recovers blocks needed by new access; parallel rollback uses multiple workers for eligible terminated-transaction recovery.
	D.	On-demand rollback makes unfinished changes permanent; parallel rollback commits all pending transactions.

4.	Which statement correctly explains checkpointing? Select one answer.
	A.	It periodically repairs every corrupt block.
	B.	It commits every active transaction.
	C.	It copies application rows to a remote replica.
	D.	It advances recovery progress as DBWn writes dirty database buffers to datafiles; CKPT coordinates checkpoint information.

5.	Which comparison between Fast-Start checkpointing and on-demand rollback is correct? Select one answer.
	A.	Both are commands that users must run before every SELECT.
	B.	Checkpointing reduces outstanding crash-recovery work during normal operation; on-demand rollback addresses needed blocks affected by terminated transactions.
	C.	Checkpointing validates RMAN backup pieces; on-demand rollback restores missing datafiles.
	D.	Checkpointing and on-demand rollback are two names for Data Guard failover.