SYSTEM-Config中,Use hot start为TRUE、I/O Recovery为RECOVERY ALL,在机器人重启后恢复所有信号的状态。
第1题:
You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()
第2题:
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()
第3题:
Which of the following is the BEST solution for repairing a hard drive that results in the NTLDR ismissing display upon booting?()
第4题:
You decided to change the location of the flash recovery area. You executed the following command: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’; Which statement is true?()
第5题:
What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()
第6题:
What is the purpose of the RMAN recovery catalog?()
第7题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第8题:
You install a Zip device on your Windows 2000 Professional computer. You reboot your computer only to find out that the computer does not respond at all. You reboot into Safe Mode, and again, the computer does not respond. How do you recover from this problem?()
第9题:
You are the Exchange administrator of the Xxx Corporation’s Exchange 2010 organization.You need to retrieve all messages from Ann’s mailbox that have the word "classified" in the message body and the subject of "New Project." The message may be either in the Calendar or Inbox folders. What should you do?()
第10题:
Perform Export before TSPITR and Import after TSPITR
Move objects to another schema that has the same tablespace assigned
Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
第11题:
Enable the flash recovery area and specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
Enable the flash recovery area but do not specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
第12题:
You will need to open the database with the resetlogs command.
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
You will use the resetlogs version of the create controlfile command.
You will use the noresetlogs version of the create controlfile command.
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
第13题:
Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()
第14题:
Which of the following is the BEST solution for repairing a hard drive that results in the Could not readfrom selected boot disk display upon booting? ()
第15题:
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()
第16题:
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()
第17题:
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery()
第18题:
What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery?()
第19题:
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()
第20题:
You have an enterprise subordinate certification authority (CA) configured for key archival. Three key recovery agent certificates are issued. The CA is configured to use two recovery agents. You need to ensure that all of the recovery agent certificates can be used to recover all new private keys. What should you do()
第21题:
The location can be changed only if the flash recovery area is empty.
After executing the command, all new flash recovery area files will be created in the new location.
The command will generate an error because you cannot change the flash recovery area while the database is open.
All the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.
第22题:
On startup, SMON coordinates instance recovery.
On startup, CKPT coordinates instance recovery.
On startup, use RMAN to perform instance recovery.
Uncommitted changes will be rolled back after the database is opened.
On startup, perform media recovery and then instance recovery.
On startup, all the files will be synchronized and you get both committed and uncommitted data.
第23题:
The location can be changed only if the flash recovery area is empty.
After executing the command, all new flash recovery area files will be created in the new location.
The command will generate an error because you cannot change the flash recovery area while the database is open.
All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.