单项选择题

What is the proper procedure to recover a lost tempfile？（）

A. Restore the backup copy of the tempfile from the backup media.
B. Re-create the tempfile with the create tempfile command.
C. Copy an existing tempfile from another database.
D. Re-create the tempfile with the create tablespace command.
E. Re-create the tempfile with the alter tablespace command.

<上一题目录下一题>

热门试题

多项选择题WhichfilesarerequiredforafullrecoveryofthedatabaseinARCHIVELOGmode？（）

A. Database datafiles
B. Online redo logs
C. Archived redo logs
D. Backup control file
E. Control file from a backup

多项选择题Whatmethodsofpoint-in-timerecoveryareavailable？（）

A. Change-based
B. Cancel-based
C. Time-based
D. Sequence number-based
E. Transaction number-based

单项选择题Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（） a. Issue a checkpoint. b. Shut down the database. c. Issue an alter database open command to open the database. d. Startup mount the database. e. Issue an alter database clear logfile command. f. Recover all database datafiles.

A.a， b， c， d
B.b， d， e， c
C.a， b， d， e， c
D.b， f， d， f， c
E.b， d， a， c

多项选择题WhichfileswillyouneedtoperformafullrecoveryofadatabasebackedupinNOARCHIVELOGmode？（）

A. Database datafiles
B. Control files
C. Archived redo logs
D. Online redo logs
E. Flashback logs

单项选择题You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（） a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database.

A.a， b， f， g
B.c， f， g
C.a， d， f， g
D.a， f， g
E.a， e， g