ocp 042答案解析.doc

1. In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm 在Oracle 10g 10g的 database , you have scheduled a job to update the optimizer statistics at 05:00 pm数据库，你安排了工作，更新统计信息，优化器在下午05:00 every Friday 。 The job has successfully completed 。 Which three pieces of information would you check to 每个星期五 。 every Friday. The job has successfully completed这项工作已顺利完成. Which three pieces of information哪三个信息块的， would you check to confirm that the statistics have been collected? (Choose three.) 你会检查 confirm that the statistics h ave been collected ? 确认，统计等皆 被收集 A. average row size 平均行大小 B. last analyzed date 最后分析日期 C. size of table in bytes 表的大小 ，以字节 D. size of table in database blocks 表中的数据库块大小 E. number of free blocks in the free list 块数的免费自由列表 F. number of extents present in the table 人数程度存在于表 Answer: ABD 一个工作一行日期老方块 2. You are in the middle of a transaction交易 and very crucial重要 data has been modified. 您在交易过程中的一个，非常重要的数据已被修改 。 Because of a hardware failure由于硬件 failure, the instance has shut down before synchronizing all the database files 。 失败, the instance has shut down before synchronizing同步 all the database files. 该实例已关闭前同步所有数据库文件 。 Which two statements are true? 哪两种说法 是正确的 ？ (Choose two.) A. On startup, SMON coordinates instance recovery. 在启动时，坐标的SMON实例恢复 B. On startup, CKPT coordinates instance recovery. 在启动时，珠江客运坐标实例恢复 C. On startup, use RMAN to perform instance recovery. 在启动时，使用RMAN执行实例恢复 D. Uncommitted changes will be rolled back after the database is opened. 未提交的更改将回滚后打开数据库 E. On startup, perform media recovery and then instance recovery. 在启动时，执行介质恢复，接着实例恢复 F. On startup, all the files will be synchronized and you get both committed and uncommitted data. 在启动时，所有的文件将被同步，你会得到提交和未提交的数据 Answer: AD 硬件失败打开再启动 由于硬件损坏，数据库意外掉电，这就意味着shutdown abort,当重新启动后SMON进程会自动回复实例，uncommited的数据会自动rollback同时， commited的数据而又未写到datafile中的会被写进datafile中。 3. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your d