Oracle-042全真试题库解析.pdf

Oracle Database 10g Administrator Certified Professional Oracle Database 10g: Administration 1Z0-042 全真试题翻译解析 编译：张XX 2012/9/16 北京 1. Which three pieces of information are considered while deciding the size of the undo tablespace in your database? (Choose three.) 那三条决定 undo 表空间的大小 ？ A) the size of an undo block undo 块大小 B) the size of the redo log files C) undo blocks generated per second 每秒产生的 undo 数据量 D) the size of the database buffer cache E) the value of the UNDO_RETENTION parameter UNDO_RETENTION 参数大小，为读 一致性保留多长时间 2. You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state? 在 mount 状态下可以迚行操作 ？ A) renaming the control files B) dropping a user in your database C) enabling or disabling redo log archiving 改变数据库归档模式 D) dropping a tablespace in your database E) re-creating the control files, after you lost all the control files in your database 3.You want to create a new optimized database for your transactional production environment to be used by afinancial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective? 使用 oracle 提供的什么工具来对数据库迚行创建和优化？ A) Use the CREATE DATABASE.. command to create the database with Oracle -managed files. B) Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C) Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D) Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.使用 DBCA 创建数据库 E) Use the CREATE DATABASE.. command to create