Tham khảo tài liệu 'oracle database 10g administration ii practice testversion phần 4', 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 67 Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process Choose two. A. open the database with the RESETLOGS option B. open the database with the RESTRICTED option C. recover to the required SCN only that data file in which the error occurred D. recover all the data files to the same system change number SCN Answer A D QUESTION NO 68 Jx You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option Choose two. A. This operation updates all currentdatafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp. B. This operation resets the SCN for the database. C. This operation moves all the redo log files to a different location. D. This operation deletes the old redo log files and creates new redo log files. E. This operation creates a new incarnation of the database. Answer A E QUESTION NO 69 You have an Automatic Storage Management ASM instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager RMAN you migrate the complete production database to use the ASM instance. Which statement is true A. RMAN would relocate all the database files to an ASM disk group. B. RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location defined using OMF. C. RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically. Pass Any Exam. Any Time. - 31 Oracle 1z0-043 Practice Exam D. RMAN would relocate all the data files to an ASM disk group and other files to an operating system .
