当前位置:  数据库>oracle

Oracle 10g OCP 042 题库 1-30 题 共168题

    来源: 互联网  发布时间:2017-04-21

    本文导语: 声明:对于答案的相关的说明,是个人对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. Begin...

声明:对于答案的相关的说明,是个人对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 Google iis7站长之家 desig_id;

答案:AB

Oracle Flashback 技术总结

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

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 recovery manager(RMAN) commands after creating the database.

E. Schedule the database backup using Database Configuration Assistant(DBCA) while creating the database.

答案:E.

刚看到这个答案的时候,以为答案有问题。Google一下,真有。 我们注意看题目,在安装数据库的时候,确保数据库在没有干预的情况下规则的备份。 只有E中的DBCA工具合适了。 而且DBCA 还真有这个功能(玩了几年Oracle,都没有留意到,杯具中...)

7. The application development team has developed PL/SQL procedures and functions for different purposes and calls them as and when required. The loading of individual procedures or functions into memory degrades performance with every call. Also, it causes a security problem for individual subprograms and loss of program units when the whole system is transported into a new location. Which method would you recommend to the application developers to solve this problem?

A. Avoiding the use of cursors in the subprograms.

B. Using anonymous(匿名) PL/SQL blocks instead of subprograms.

C. Referring to views instead of tables inside the subprograms.

D. creating PL/SQL packages to include interrelated(相关关联) subprograms.

答案:D.

 

8. View the Exhibit.

Your Oracle 10g database has 6 tablespaces in which:

-TEMP is the default temporary tablespace

- UNDOTBS1 is the default undo tablespace

- USERS is the default permanent tablespace

In this database, which three tablespaces can be made offline? (Choose three.)

 

A) TEMP

B) PROD

C) USERS

D) SYSAUX

E) SYSTEM

F) UNDOTBS1

答案: BCD

可以参考在线文档中 Overview of Tablespaces 小节的内容。

http://download.oracle.com/docs/cd/b28359_01/server.111/b28318/physical.htm#cncpt1089

9.  The junior DBA in your organization has accidentally deleted the alert log file. What will you do to create new alert log file?

A. Create the new text file as alert.log

B. You have to recover the alert log file from the valid backup.

C. Change the value for the BACKGROUND_DUMP_DEST parameter.

D. No action required. The file would be created automatically by the instance.

答案: D.

 

10. While planning to manage more than one database in your system,you perform the following activities:

(1) organize different categories of files into independent subdirectories.

(2) Use consistent naming convention for database files.

(3) Separate administrative information pertaining to each database.

Which option corresponds(一致) to the type of activities performed by you?

A. Oracle Managed Files.

B. Oracle Grid Architecture.

C. Optimal Flexible architecture.

D. Oracle database architecture.

答案:C

Optimal Flexible Architecture

http://download.oracle.com/docs/cd/B28359_01/install.111/b32002/app_ofa.htm#i633068


    
 
 

您可能感兴趣的文章:

  • Oracle 10g和Oracle 11g网格技术介绍
  • 虚拟机装Oracle R12与Oracle10g
  • Oracle 10g中导出到Oracle 9的问题小结
  • 安装Oracle 10g忘记sys密码
  • Oracle 10G进程体系学习笔记
  • [官方最新消息]Oracle 10G 认证考试新变化
  • SOLARIS 下如何卸载ORACLE10G
  • oracle10g 数据备份与导入
  • 为何用dbstart启动oracle10g不好用
  • linux下oracle 10g如何完全卸载?
  • Oracle 10g client for Solaris
  • 急求Linux下oracle 10g和weblogic 9的安装
  • Linux系统下利用java连接Oracle 10G
  • Linux下完全卸载ORACLE 10G的方法
  • Linux下Oracle 10G DBCA等汉字乱码解决方法
  • redhat as 4 下如何安装oracle 10g ?
  • 求助前辈们:solaris 10 x86 安装oracle 10g 错误
  • 将Oracle 8i数据成功移植Oracle 10g的方法
  • 上传一个非常详细的Oracle10G在IBMAIX 5L上的安装步骤与大家分享
  • linux as3 安装oracle10g ,web端能访问,终端用命令不能进入
  • 如何升级Oracle 9i到10g
  •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • Oracle 12c发布简单介绍及官方下载地址
  • 在linux下安装oracle,如何设置让oracle自动启动!也就是让oracle那个服务自动启动,不是手动的
  • oracle 11g最新版官方下载地址
  • 请问su oracle 和su - oracle有什么不同?
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • Oracle 数据库开发工具 Oracle SQL Developer
  • Oracle数据库(Oracle Database)体系结构及基本组成介绍
  • Oracle EBS R12 支持 Oracle Database 11g
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • SCO unix下安装oracle,但没有光盘,请大家推荐一个oracle下载站点(unix版本的)。谢谢!!!!
  • oracle中如何把表中具有相同值列的多行数据合并成一行
  • 请问大家用oracle数据库, 用import oracle.*;下的东西么? 还是用标准库?
  • Oracle 数据库(oracle Database)性能调优技术详解
  • Linux /$ORACLE_HOME $ORACLE_HOME
  • ORACLE日期相关操作
  • Linux系统下Oracle的启动与Oracle监听的启动
  • ORACLE数据库常用字段数据类型介绍
  • 请问在solaris下安装ORACLE,用root用户和用oracle用户安装有什么区别么?
  • Oracle 12c的九大最新技术特性介绍
  • 网间Oracle的连接,远程连接Oracle服务器??
  • ORACLE中DBMS_RANDOM随机数生成包
  • 请教:.profile中:if [ -d /opt/oracle/db01/app/oracle/product/9.2.0 ]是什么意思?


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3