Oracle10gOCP042题库130题共168题

原 Oracle 10g OCP 042 题库 1-30 题 共168题https://blog.csdn.net/tianlesoftware/article/details/5767606版权声明： https://blog.csdn.net/tianlesoftware/article/details/5767606
声明：对于答案的相关的说明，是个人对Oracle的理解。
1. Because of a power outage,instance failure has occurred. From what point in the redo log does recovery begin and where does it end?
A. Current redo log and inactive redo log
B. Checkpoint position to end of redo log
C. Beginning of redo log to end of redo log
D. All redo logs before the point of last commit
E. Beginning of redo log to checkpoint position.
答案B.  Checkpoint 之前的数据已经写入到数据文件。 所以用restore 就可以恢复。 而checkpoint之后的数据没有写入到数据文件，所以需要进行recovery。 Recovery时，对于已经commit的数据，前滚写入到数据文件。 没有commit的数据，进行回滚。
2. Which two operations can be flashed back using the flashback technology? (choose two)
A. Drop user smith;
B. Drop table employees;
C. Drop tablespace users;
D. Alter table sales_rep drop partition p1;
E. Alter table employees drop column desig_id;
答案：AB。
Oracle Flashback 技术 总结
http://blog.csdn.net/tianlesoftware/archive/2009/10/16/4677378.aspx
  3. You have to shut down the database instance with the abort option because of a hardware failure. Which statement is true about the subsequent opening of the database?
A. The database would open normally.
B. The database would not open,and it would stop at mount stage.
C. The database would open alter automatically performing instance recovery.
D. The database would not open, and have to perform database recovery to open it.
答案： C. 
如果实例异常关闭（宕机，shutdown abort），并且数据文件，控制文件，联机日志都没有丢失。在下次启动时，要利用联机日志的内容进行恢复，这种恢复就是实例恢复（Instance Recovery）。
Instance Recovery 主要包括3个阶段：
1） 根据联机日志内容进行Rollover。
2） 打开数据库，提供服务
3） SMON 或者用户进程进行Rollback。
具体参考 Oracle 备份与恢复概述 中的 3.2 节 恢复种类
http://blog.csdn.net/tianlesoftware/archive/2010/04/16/5490733.aspx
    4. You backed up the control file to trace. Which statement is true about the trace file generated?
A. The trace file is in binary format.
B. The trace file has a SQL scripts to re-create the control file.
C. The trace file is a backup set created during the backup of the control file.
D. The trace file contains the instructions to manually re-create the control file.
E. The trace file is an image copy of the control file created during the backup of the the control file.
答案： B
联机文档：
An alternative to the CREATE CONTROLFILE statement is ALTER DATABASE BACKUP CONTROLFILE TO TRACE, which generates a SQL script in the trace file to re-create the controlfile
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5003.htm
    5. While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software,you are prompted to run orainstRoot.sh. What does this scripts accomplish?
A. It creates the pointer file.
B. It creates the base directory.
C. It creates the inventory pointer file.
D. It creates the Oracle user for installation.
E. It modifies the Unix kernel parmeters to match Oracle's requirement.
答案： C
可以查看$ORACLE_BASE/oraInventory/orainstRoot.sh 脚本的内容。该脚本实际上完成了以下工作：
（1）创建software inventory location pointer file: /etc/oraInst.loc，内容为
      inventory_loc=$ORACLE_BASE/oraInventory
     inst_group=oinstall
   修改该文件属性:chmod 644 /etc/oraInst.loc 
（2）创建inventory directory: $ORACLE_BASE/oraInventory
   修改文件属性： chmod -R 770 $ORACLE_BASE/oraInventory
                chgrp oinstall $ORACLE_BASE/oraInventory
  oraInventory目录是用来存储oracle安装的所有软件组件的信息的，每个组件可能占用150k的空间.
  6. While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention(介入). What should you do to achieve the objective?
A. Configure the database to run in archivelog mode.
B. Configure the Flash recovery area to enable automatic database backup.
C. Schedule the database backup using DBMS_JOB package after creating the database.
D. Schedule the database backup using recover