没有合适的资源?快使用搜索试试~ 我知道了~
首页1z0-053最全题库(笔记版--考试之后总结版)
资源详情
资源评论
资源推荐
The safer , easier way to help you pass any IT exams.
1 / 193
Exam
: 1Z0-053
Title :
Version : V13.02
Oracle Database 11g:
Administration II
The safer , easier way to help you pass any IT exams.
2 / 193
1.While deploying a new application module, the software vendor ships the application software along
with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe
the consequences? (Choose two.)
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance
under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline
has been imported.
Answer: AC
2.You plan to have a larger moving window size for the default system-defined moving window baseline
because you want to use the adaptive threshold.
Which statement factors in this consideration while increasing the size of the moving window.?
A. The collection level for the AWR should be set to BASIC.
B. The moving window size must be less than Undo Retention.
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention
period.
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR)
retention period.
Answer: D
3.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains
one redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';
Answer: C
4.Which three components does the Scheduler use for managing tasks within the Oracle environment?
(Choose three.)
A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
Answer: ABC
5.Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
The safer , easier way to help you pass any IT exams.
3 / 193
Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :
REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :
2007-05-12 22:11:20.835135 -07:00 Error Encountered : 0
Source Incident Id : 7418
Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)
A. Health Check was performed manually.
B. Health Check was performed to check the disk image block corruptions.
C. Health Check was performed to check interblock and intersegment corruption.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed by the Health Monitor automatically in response to a critical error.
Answer: AB
6.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema
owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog
schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10,
into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10
catalog?
A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C. The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
Answer: D
7.You need to configure fine-grained access control to external network resources from within your
database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
A. It is a list of remote database links stored in the XML file that are available to the users of the database.
B. It is a list of users and network privileges stored in the XML file according to which a group of users can
connect to one or more hosts.
C. It is a list of users and network privileges stored in the data dictionary according to which a group of
users can connect to one or more hosts.
D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your
database through PL/SQL network utility packages such as UTL_TCP.
Answer: B
8.Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile
LOBs?
A. It cannot be done in parallel.
The safer , easier way to help you pass any IT exams.
4 / 193
B. It can be done at the table level or partition level.
C. It does not require additional storage because the operation is done online.
D. Local and global indexes are maintained automatically during the operation.
Answer: B
9.Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure
for LOB space usage?
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned
tables.
Answer: B
10.Consider the following scenario for your database:
-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most
recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement
is true regarding the backup of the TOOLS tablespace?
A. The RMAN backup fails because the TOOLS tablespace is read-only
B. The RMAN skips the backup of the tablespace because backup optimization is enabled
C. The RMAN makes backup because optimization can be enabled only for backups to disk
D. The RMAN makes the backup because no backup of the tablespace exists within the seven day
window
Answer: D
11.View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the
Number of Transactions (per second) metric?
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the
metric.
B. The statistics for the metric values observed over the baseline time period are not examined to
determine threshold values.
C. Oracle determines when an adaptive threshold has been breached based on the maximum value
captured by the baseline.
D. The total concurrent number of threshold violations, which must occur before an alert is raised for the
metric, has been set to zero.
剩余202页未读,继续阅读
qq_37831529
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
- MW全能培训汽轮机调节保安系统PPT教学课件.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论1