Tham khảo tài liệu 'oracle database 10g administration ii practice testversion phần 6', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Oracle 1z0-043 Practice Exam QUESTION NO 112 You lost a data file that belongs to an index tablespace in your database which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem Choose two. A. restore the data file pertaining to indextablespace and then recover the tablespace B. restore all the data files and then perform an incomplete recovery using the backup control file C. drop and re-create the indextablespace and then re-create all of the indexes in that tablespace D. restore all the data files and then perform an incomplete recovery to get thetablespace back E. restore the lost data file from the backup and then flash back the database Answer A C QUESTION NO 113 The warning and critical threshold values have been set to 85 and 97 respectively for one of the tablespaces. The current tablespace space usage is 54 . You modify the warning threshold to be 50 and critical threshold to be 53 in Database Control. Which statement is true A. The new setting would cause an error because thetablespace space usage is more than the specified threshold value. B. The new setting would be applied but no alerts would be raised immediately. C. The new setting would be applied and an alert would be raised immediately. D. The new setting would be ignored because thetablespace space usage is more than the specified threshold value. Answer B QUESTION NO 114 You executed the following command in Recovery Manager RMAN to perform a backup of the DETTBS tablespace RMAN BACKUP TABLESPACE DETTBS Under which conditions would this command execute successfully Choose all that apply. A. The database is in NOARCHIVELOG mode and thetablespace is online. B. The database is in NOARCHIVELOG mode and thetablespace is offline. Pass Any Exam. Any Time. - 51 Oracle 1z0-043 Practice Exam C. The database is in NOMOUNT state. D. The database is in ARCHIVELOG mode and .
