当前位置:  数据库>oracle

Oracle 10g OCP 042 题库 31-70 题 共168题

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

    本文导语: 31. Which two statements are true regarding the database in ARCHIVELOG mode? (Choose two.) A) You have to shut down the database to perform the backups. B) Archiving information is written to the data files and redo log files. C) You can perform complete database backups without closing the datab...

31. Which two statements are true regarding the database in ARCHIVELOG mode? (Choose two.)

A) You have to shut down the database to perform the backups.

B) Archiving information is written to the data files and redo log files.

C) You can perform complete database backups without closing the database.

D) Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

E) All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

答案:C E.

32.  You perform differential incremental level 1 backups of your database on each working day and level 0

backup on Sundays. Which two statements are true about the differential incremental backups? (Choose two.)

A) The backup performed on Sundays contains all the blocks that have ever been use in the database.

B) The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.

C) The backup performed on each working day contains all the blocks that have changed since the last level 0 or level

1 backup.

D) The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.

答案: A C

 

33.  You require the Oracle server to manage the undo segments and space among various active sessions

automatically. You created an undo tablespace, UNDO_TBS1, in your database. Which two additional steps

would you perform to achieve this? (Choose two.)

a) set the undo_retention parameter to 900 or more.

B) Create an initial undo segment in the undo tablespace.

C) Enable the retention guarantee for the undo tablespace.

d) set the undo_tablespace parameter to undo_tbs1.

E) Set the UNDO_MANAGEMENT initialization parameter to AUTO.

答案:DE

Oracle undo 管理

34. Which two statements are true regarding a PL/SQL package body? (Choose two.)

A) It cannot be created without a package specification.

B) It cannot invoke subprograms defined in other packages.

C) It can contain only the subprograms defined in the package specification.

D) It can be changed and recompiled without making the package specification invalid.

答案:AD

35. User A executes the following command to update the TRANS table)

SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';

Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the

TRANS table:

SQl> ALTER TABLE trans MODIFY (tr_type VARCHAR2 (3));

What would happen in this scenario?

A) The transaction for user A is rolled back.

B) The ALTER TABLE command modifies the column successfully.

C) The ALTER TABLE command fails due to the resource being busy.

D) The ALTER TABLE command waits until user A ends the transaction.

答案:C

36. Which three statements are true regarding the fine-grained auditing (FGA)? (Choose three.)

A) FGA is possible on SELECT statements only.

B) The audit trail for FGA is stored in the FGA_LOG$ table.

C) The audit trail for FGA is stored in the AUD_LOG$ table.

D) FGA enables a SQL predicate to define when to audit an event.

E) FGA audits DELETE statements only when audit columns are specified.

F) FGA includes the SQL statement used by the user as part of the audit event entry.

答案:B D F

理解的也不是很透彻,参考 About Fine-Grained Auditing 小节:

http://download.oracle.com/docs/cd/e11882_01/network.112/e10574/auditing.htm#dbseg60681

37. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in

iSQL*Plus?

A) The user must be granted the database administrator (DBA) privilege.

B) The user must be listed in the password file for the authentication.

C) No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

D) Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba

role to the user.

答案:D

38. In your Oracle 10g database, you have scheduled a job to update the optimizer statistics at 05) 00 pm

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.)

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

答案:ABD

http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/stats.htm#PFGRF94712

16.5.1 verifying optimizer statistics

http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/sql_overview.htm#PFGRF94815

39. Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:

LSNRCTL> STOP

What would happen to the sessions that are presently connected to the database instance?

A) The sessions are able to perform only queries.

B) The sessions are not affected and continue to function normally.

C) The active transactions are rolled back and the sessions get terminated.

D) The sessions are not allowed to perform any operations till the listener is started.  

答案:B

40. After being hired as a database administrator, you find that there is only one database that is functional

and that is being accessed by the applications. You want to create a replica of the database, to be used for

testing purposes. What is the best method to create the replica?

A) create a database by using CREATE DATABASE .. command and manually copy the data

B) use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the

database structure

C) use DBCA to create a template from the existing database to contain the database structure and then manually

copy the data using Oracle Data Pump

D) use DBCA to create a template from the existing database to contain the database structure with data files and then

use the same template to create the database in the new location

答案:D

41. You are working on the 24X7 database with high transaction volume, to ensure faster instance bytes iis7站长之家 on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?

A) The database performance would be enhanced.

B) The redo log files would be get filled more frequently.

C) The overall database performance would be degraded.

D) The mean time to recover (MTTR) would be increased.

答案:C

10.5.3 Tuning FAST_START_MTTR_TARGET and Using MTTR Advisor

http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/instance_tune.htm#PFGRF13015

42. You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2:00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2:00 p.m.?

a) perform point-in-time recovery to 2:00 p.m.

B) Use Flashback Table feature to revert the changes.

C) Restore the entire database from the recent backup and open it.

D) Issue the rollback statement with system change number (SCN).

 答案:B

Oracle Flashback 技术总结

43. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?

A) The backup is similar to image copy.

B) The backup contains all used data blocks.

C) The backup contains only unused data blocks.

D) The backup contains all data blocks changed since the last incremental level 1 backup.

答案:B


    
 
 

您可能感兴趣的文章:

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