Infrequent Recovery Situations - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1.	The complete recovery method--recovering a datafile with no backup--can be used in which of the following situations? Please select the best answer.
	A.	The corrupted datafiles belong to the system tablespace and have no backup, but all archived logs exist since the file was created.
	B.	The corrupted datafiles have no backup and all archived logs exist since the file was created.
	C.	The datafiles needing recovery have no backup and some of the archived logs since the creation of these datafiles are damaged.
	D.	The damaged datafile belongs to a rollback segment tablespace and has no backup, but all archived logs exist since the datafile was created.

2.	To check the backup status of all online datafiles, which data dictionary view do you use? Please select the best answer.
	A.	V$BACKUP_DATAFILE
	B.	V$RECOVER_FILE
	C.	V$BACKUP
	D.	V$BACKUP_REDOLOG

Correct answers:

Your Score: 0