当前位置:  数据库>oracle

Oracle 10g OCP 042 题库 71-120 题 共168题

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

    本文导语: 71. Your database instance is started using the server parameter file (SPFILE). Control files are multiplexed and stored on different disks. Because of a disk failure, you lost one of these control files. You replaced the damaged disk. What is the correct sequence of steps that you would follow to r...

71. Your database instance is started using the server parameter file (SPFILE). Control files are multiplexed and stored on different disks. Because of a disk failure, you lost one of these control files. You replaced the damaged disk. What is the correct sequence of steps that you would follow to recover the control file?

1. shut down the instance, if not already done.

2. Copy one of the remaining control files to a new location.

3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.

4. Start up the database instance to the NOMOUNT stage.

5. Recover the database to the point of failure of the control file.

6. Open the database.

A) 5,2,3,4

B) 1, 2,4,3,5

C) 2, 4,3,4,5

D) 4, 5,6,2,3

答案:B

72. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?

A) implementing value-based auditing by using triggers

B) implementing fine-grained auditing with audit condition and event handler

C) performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED

D) performing standard database auditing to audit SQL statements with granularity level set to ACCESS

答案:B

73. The user SCOTT executes the following command successfully to increase the salary values in one of his sessions:

SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20;

Before SCOTT ends the transaction, user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values.

Why does HR still see the old data?

A) because of redo data from redo log file

B) because of data from database buffer cache

C) because of data from a temporary tablespace

D) because of undo data from the undo tablespace

答案:D

74. View the Exhibit and examine the output.

Which statement describes the conclusion?

A) The users should use bind variables instead of literals in the query.

B) The dictionary cache is consuming more space than the library cache.

C) The shared pool size should be increased to accommodate the SQL statements.

D) Preparing indexes on the tables used in the SQL statements would improve the library cache performance.

答案:A

Oracle 绑定变量

75. In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database? (Choose two.)

A) The database instance aborts.

B) The database operation temporarily halts till the member becomes available.

C) Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.

D) The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.

E) The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

答案:CD

 

76. Your database is not configured for session failover. Your tnsnames.ora file contains the following details:

test.us.oracle.com=

(DESCRIPTION=

(ADDRESS_LIST=

(LOAD_BALANCE=off)

(FAILOVER=ON)

(ADDRESS= (PROTOCOL=tcp) (HOST=test1-server) (PORT=1521))

(ADDRESS= (PROTOCOL=tcp) (HOST=test2-server) (PORT=1521)))

(CONNECT_DATA= (SERVICE_NAME=test.us.oracle.com)))

Which feature is enabled in this case?

A) Load balancing

B) Instance failover

C) Database failover

D) Connect-time failover

E) Transparent Application Failover (TAF)

答案:D

 

77. On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.)

A) data files

B) control files

C) tablespaces

D) password file

E) parameter file

F) whole database

G) flashback log file

H) archived log files

I) change tracking file

答案:ACF

 

78. You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space.

Which area would you refer to, in order to confirm that the alert has been raised due the event?

A) the alert.log file

B) the DBA_query iis7站长之家 view

C) the Database Control Home page

D) the Database Control performance page

E) the Database Control Maintenance page

答案:C

 

79. A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work.

ORA-02392: exceeded session limit on CPU usage, you are being logged off

Which action would you take to increase the session limit on CPU usage?

A) Modify the profile assigned to the user.

B) Modify the roles assigned to the users.

C) Modify the object privileges assigned to the user.

D) Modify the system privileges assigned to the users.

E) Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

答案:A

 

80.  You execute the following command to audit the database activities:

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;

What is the effect of this command?

A) One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

B) One audit record is created for every session when any user successfully drops a table owned by SCOTT.

C) One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

D) One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

E) One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

答案:A

 

81.  Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)

A) The corresponding indexes for the table are also truncated.

B) Delete triggers on the table are fired during the execution of the TRUNCATE command.

C) Very little or no undo data is generated during the execution of the TRUNCATE command.

D) The child table is truncated when the TRUNCATE command is applied on the parent table.

E) The high-water mark (HWM) is set to point to the first useable data block in the table segment.

答案:ACE

If table is not empty, then the database marks UNUSABLE all nonpartitioned indexes and all partitions of global partitioned indexes on the table. However, when the table is truncated, the index is also truncated, and a new high water mark is calculated for the index segment. This operation is equivalent to creating a new segment for the index. Therefore, at the end of the truncate operation, the indexes are once again USABLE.

http://download.oracle.com/docs/cd/e11882_01/server.112/e10592/statements_10007.htm#sqlrf01707

82. Which is the correct description of the significance of the ORACLE_HOME environmental variable?

A) It specifies the directory containing the Oracle software.

B) It specifies the directory containing the Oracle-Managed Files.

C) It specifies the directory for database files, if not specified explicitly.

D) It specifies the base directory of Optimal Flexible Architecture (OFA) .

答案:A


    
 
 

您可能感兴趣的文章:

  • 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,