AThe location can be changed only if the flash recovery area is empty.
BAfter executing the command, all new flash recovery area files will be created in the new location.
CThe command will generate an error because you cannot change the flash recovery area while the database is open.
DAll 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.
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
多选题查看答案
You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()
单选题查看答案
You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()
多选题查看答案
In which situation are you NOT required to perform an incomplete recovery?()
单选题查看答案
You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process?()
单选题查看答案
You want the size of the tablespace to increase when it is full. Which option would you use?()
单选题查看答案
Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()
单选题查看答案
You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics?()
单选题查看答案
You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file?()
多选题查看答案