Backup control file.
Emergency control file.
The create controlfile command.
The restore controlfile SQL*Plus command.
No backup is required. The database will re-create the control file when it is discovered to be lost.
第1题:
When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()
第2题:
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.
第3题:
What methods are available to recover lost control files?()
第4题:
Which three statements are true about the stages of database startup?()
第5题:
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
第6题:
Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
第7题:
What 2 methods are available for overcoming the BGP full mesh requirement?
第8题:
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()
第9题:
When performing an incomplete recover of the whole database, which data files must you restore? ()
第10题:
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()