当前位置:  数据库>oracle

Oracle 10g OCP 042 题库 121-166题 共168题

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

    本文导语: 121. You want to create a new optimized database for your transactional production environment to be used by a financial 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 achie...

121. You want to create a new optimized database for your transactional production environment to be used by a financial 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?

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.

E) Use the CREATE DATABASE.. command to create the database with Automatic Storage Management (ASM) file system.

答案: D

122. You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?

A) run Segment Advisor

B) run SQL Tuning Advisor on top SQL statements

C) run the Automatic Workload Repository (AWR) report

D) run the Automatic Database Diagnostic Monitor (ADDM) on top SQL statements

答案:B

 

123. View the Exhibit.

    

Which statement regarding the dept and emp tables is true?

A) When you delete a row from the emp table, you would receive a constraint violation error.

B) When you delete a row from the dept table, you would receive a constraint violation error.

C) When you delete a row from the emp table, automatically the corresponding rows are deleted from the dept table.

D) When you delete a row from the dept table, automatically the corresponding rows are deleted from the emp table.

E) When you delete a row from the dept table, automatically the corresponding rows are updated with null values in the emp table.

F) When you delete a row from the emp table, automatically the corresponding rows are updated with null values in the dept table.

答案:D

 

124. User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to? (Choose two.)

A) null lock on the row being updated

B) null lock on the table containing the row

C) ROW SHARE lock for the row being updated

D) ROW EXCLUSIVE lock for the row being updated

E) shared row-exclusive lock for the row being updated

F) a shareable table lock for the table containing the row

G) exclusive table-level lock for the table containing the row

答案:DF

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

126. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario? (Choose two.)

A) The instance aborts.

B) The database cannot be recovered.

C) The database can be recovered by restoring the control files from the backup.

D) The database remains opened and you have to shut it down with the ABORT option.

E) The database can be restored till the point of the last closed whole database backup.

答案:AE

 

127. While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software, you are prompted to run orainstRoot.sh script. What does this script 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 parameters to match Oracle's requirement.

答案: C

 

 

128.  Your database is started with SPFILE. You want the database instance to be dynamically registered with a

listener L2 with the following details:

Protocol: TCP

Host: indl151e

Port: 1525

Which is the correct order of the steps that you would follow to achieve this?

1. Set the LOCAL_LISTENER parameter to L2 dynamically.

2. Make an entry for L2 in tnsnames.ora on the database server.

3. Restart L2.

4. Modify the listener.ora file to add the instance name in SID_LIST of L2.

A) 1, 2, 4, 3

B) 1, 2, 3; 4 is not required.

C) 2, 1; 3 and 4 are not required.

D) 1, 2; 3 and 4 are not required.

答案:C

 

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

130.  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 two tablespaces can be made read only? (Choose two.)

A) TEMP

B) PROD

C) USERS

D) SYSAUX

E) SYSTEM

F) UNDOTBS1

答案: BC

 

131. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?

A) SQL script

B) PL/SQL script

C) Operating System (OS) script

D) Enterprise Manager (EM) script

E) Recovery Manager (RMAN) script

答案: E


    
 
 

您可能感兴趣的文章:

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