没有合适的资源?快使用搜索试试~ 我知道了~
首页OCP 1Z0-053 V12.02: Oracle Database 11g Administration II备考指南
OCP 1Z0-053 V12.02: Oracle Database 11g Administration II备考指南
需积分: 9 6 下载量 48 浏览量
更新于2024-07-24
收藏 2.43MB PDF 举报
"OCP考试_1Z0-053 V12.02_new.pdf" 是针对Oracle Database 11g: Administration II的认证考试资料,主要关注于管理员级别的知识。这份文档的核心主题是帮助考生准备1Z0-053考试,该考试专注于Oracle数据库的高级管理技能。 在提供的部分内容中,第一个问题涉及数据库部署和SQL计划基线的使用。当软件供应商提供新的应用模块时,会附带相应的SQL计划基线,以优化新引入的SQL语句性能。选项A正确,因为随着时间的推移,计划基线可以逐步改进,以实现更好的执行效率。选项B错误,因为新生成的计划需要经过验证后才能加入到基线中,而不是直接添加。选项C正确,新SQL语句最初会使用已知性能良好的计划运行,直到它们适应标准测试配置。选项D错误,即使导入了SQL计划基线,优化器仍可能为那些SQL语句生成新的计划,以便持续优化。 第二个问题聚焦于默认系统定义的移动窗口基准的调整。考生需要考虑增加移动窗口大小以使用自适应阈值时,哪个因素会被纳入考量。选项A提到的“collection level for AWR”(自适应工作负载报告的收集级别)可能是一个关键因素,因为收集级别设置可能影响性能监控的数据精度和频率,从而影响对移动窗口大小的选择。 这个文档涵盖了Oracle数据库11g的高级管理内容,如SQL计划管理、性能监控和优化策略,旨在帮助考生深入理解并准备通过1Z0-053考试。备考过程中,考生不仅需要熟悉基础概念,还要了解如何在实际环境中应用这些知识来优化数据库性能。
资源详情
资源推荐
![](https://csdnimg.cn/release/download_crawler_static/6279787/bg10.jpg)
The
safer , easier way to help you pass any IT exams.
16
/
181
C. Set the DB_LOCK_CH
ECKSUM parameter to TYPICAL.
D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.
Answer:
B
53.You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use?
A. The BZIP2 compression algo
rithm consumes more CPU resources than the ZLIB compression
algorithm.
B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression
algorithm.
C. The ZLIB compression algorithm provides maximum compression and produces smaller b
ackups than
the BZIP2 compression algorithm.
D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
Answer:
A
54.Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHE
RELIES_ON
(EMPLOYEES) IS avgsal NUMBER(6);
BEGIN
SELECT AVG(SALARY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENT_ID = dept_id;
RETURN avgsal;
END get_dept_avg;
Which statement is true regarding the above function?
A. The cached result becomes invalid when a
ny structural change is done to the EMPLOYEES table.
B. If the function execution results in an unhandled exception, the exception result is also stored in the
cache.
C. Each time the function is invoked in a different session, the current result in the re
sult cache gets
overwritten.
D. If the function is invoked with a different parameter value, the existing result in the result cache gets
overwritten by the latest value.
Answer:
A
55.Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab
2.$ORACLE_HOME/dbs/oranfstab
3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?
A. 1, 2, 3
B. 3, 2, 1
C. 2, 3, 1
D. 1, 3, 2
![](https://csdnimg.cn/release/download_crawler_static/6279787/bg11.jpg)
The
safer , easier way to help you pass any IT exams.
17
/
181
Answer:
C
56.You discover that your Recycle Bin contains two tables with t
he same name, MY_TABLE. You also
have a table named MY_TABLE in your schema. You execute the following statement:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;
What will be the result of executing this statement?
A. One of the tables is reco
vered from the Recycle Bin using a First In First Out (FIFO) approach.
B. One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABL
E2 and the
other to a system
-
generated name.
D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.
Answer:
B
57.Which background process of a database instance, using Automatic Storage Management (ASM),
connects as
a foreground process into the ASM instance?
A. ASMB
B. PMON
C. RBAL
D. SMON
Answer:
A
58.Which statement is true when Automatic Workload Repository (AWR) baselines are created using
baseline templates?
A. AWR baselines are always created as repeating base
lines.
B. AWR baselines can be created on the basis of two time values.
C. AWR baselines are always created with infinite expiration duration.
D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period
as expiration
duration.
Answer:
B
59.You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the
entire datafile every time an incremental backup is performed. You decide to enable the block change
tracking feature. Which statement
should you use to enable the block change tracking feature?
A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
D. ALTER SYSTEM EN
ABLE BLOCK CHANGE TRACKING;
Answer:
C
60.For which two situations would you use functionality provided by the Resource Manager? (Choose
two.)
A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creat
ing jobs that will run automatically at a scheduled time
![](https://csdnimg.cn/release/download_crawler_static/6279787/bg12.jpg)
The
safer , easier way to help you pass any IT exams.
18
/
181
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources
Answer:
AD
61.Which of the follo
wing advisors within the Oracle advisory framework will analyze a single SQL
statement and make recommendations for performance improvement?
A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor
Answer:
D
62.You want to conver
t your existing non
-
ASM files to ASM files for the database PROD. Which method
or command would you use to accomplish this task?
A. Data Pump Export and Import
B. conventional export and import
C. the CONVERT command of RMAN
D. the BACKUP AS COPY. command
of RMAN
Answer:
D
63.Which method would you use to undo the changes made by a particular transaction without affecting
the changes made by other transactions?
A. point
-
in
-
time recovery
B. execute the ROLLBACK command with transaction number
C. flashback t
he database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and
use them for recovery
Answer:
D
64.You performed an incomplete recovery and opened the database with the RESETLOGS
option. The
LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the
archived redo log files, created in an earlier incarnation of the database, is true?
A. The archived redo log files will be overwritten.
B. The archived re
do log files are deleted automatically.
C. The archived redo log files should be moved to some other location.
D. The archived redo log files are still maintained because the file names are unique.
Answer:
D
65.An online tablespace, TEST_TBS, is full and
you realize that no server
-
managed tablespace threshold
alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS
tablespace does not include autoextensible data files?
A. TEST_TBS is a small file tablespace.
B. TEST_TBS
is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace.
![](https://csdnimg.cn/release/download_crawler_static/6279787/bg13.jpg)
The
safer , easier way to help you pass any IT exams.
19
/
181
D. TEST_TBS is a dictionary
-
managed tablespace.
Answer:
D
66.Which two initialization parameters would you set to enable Automatic Shared Memory Management?
(Choose two.)
A. s
et SHARED_POOL_SIZE to zero
B. set STATISTICS_LEVEL to BASIC
C. set SGA_TARGET to a non
-
zero value
D. set DB_CACHE_SIZE to a non
-
zero value
E. set STATISTICS_LEVEL to TYPICAL or ALL
Answer:
AC
67.On which two database objects can the VERSIONS clause of th
e Flashback Versions Query be used?
(Choose two.)
A. fixed tables
B. heap tables
C. external tables
D. temporary tables
E. Index
-
Organized Tables (IOTs)
Answer:
BE
68.You have three temporary tablespace groups named G1, G2, and G3 in your database. You ar
e
creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE
GROUP '';
Which statement regarding the above command is correct?
A. It will create the tablespace TEMP1 in group G1.
B. I
t will create the tablespace TEMP1 in group G3.
C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group.
Answer:
C
69.
The EMP table exists in your schema. You want
to execute the following query:
S
ELECT ename, sal
FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP
-
INTERVAL '6' MINUTE)
WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply)
A.
ARCHIVELOG
mode must be enabled
B.
Row Movement m
ust
be enabled for the table
C.
FLASHBACK must be set to ON for the database
D.
The UNDO_MANAGEMENT p
arameter must be set to AUTO
E.
The UNDO_RETENTION param
eter must be set appropriately
Answer:
DE
![](https://csdnimg.cn/release/download_crawler_static/6279787/bg14.jpg)
The
safer , easier way to help you pass any IT exams.
20
/
181
70.You executed the following SQL statement to shrink the EMPL
OYEES table segment stored in the
EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?
A. The EMPLOYEES table will be changed to read
-
only mode during the shrink operation.
B. The indexes created on t
he EMPLOYEES table will need to be rebuilt after the shrink operation is over.
C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink
operation.
D. Data manipulation language (DML) operations will not be possib
le on the EMPLOYEES table during
the COMPACTION phase of the shrink operation.
Answer:
C
71.The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your
database. Your database is facing a series of interrelated problems over a
period of two hours. You need
to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?
A. Create two custom ADDM tasks.
B. Modify the AWR snapshot time interval to two hours.
C. Create a new scheduler window for a
time period of two hours.
D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
Answer:
B
72.You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running
low on space.
You can use Seg
ment Advisor to _____.
A. identify the segments that you should shrink
B. modify the storage parameters for the tablespace
C. automatically shrink the segments with unused space
D. check the alerts generated for the tablespace that is running low on space
Answer:
A
73.You are using Recovery Manager (RMAN) to perform backups. In which three situations would you
perform a compressed backup? (Choose three.)
A. You are backing up to tape and your tape device performs its own compression.
B. You are making imag
e copies, and you have not enabled tablespace compression.
C. You are using disk
-
based backups and disk space in your Flash Recovery Area, or other disk
-
based
backup destinations are limited.
D. You are performing your backups to some device over a network
where reduced network bandwidth is
more important than CPU usage.
E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves
media costs and archival storage.
Answer:
CDE
74.Immediately after adding a new disk to or
removing an existing disk from an ASM instance, you find
剩余180页未读,继续阅读
![apkg](https://img-home.csdnimg.cn/images/20210720083646.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://profile-avatar.csdnimg.cn/default.jpg!1)
njchic123
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![](https://csdnimg.cn/release/wenkucmsfe/public/img/voice.245cc511.png)
最新资源
- 解决本地连接丢失无法上网的问题
- BIOS报警声音解析:故障原因与解决方法
- 广义均值移动跟踪算法在视频目标跟踪中的应用研究
- C++Builder快捷键大全:高效编程的秘密武器
- 网页制作入门:常用代码详解
- TX2440A开发板网络远程监控系统移植教程:易搭建与通用解决方案
- WebLogic10虚拟内存配置详解与优化技巧
- C#网络编程深度解析:Socket基础与应用
- 掌握Struts1:Java MVC轻量级框架详解
- 20个必备CSS代码段提升Web开发效率
- CSS样式大全:字体、文本、列表样式详解
- Proteus元件库大全:从基础到高级组件
- 74HC08芯片:高速CMOS四输入与门详细资料
- C#获取当前路径的多种方法详解
- 修复MySQL乱码问题:设置字符集为GB2312
- C语言的诞生与演进:从汇编到系统编程的革命
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
![](https://img-home.csdnimg.cn/images/20220527035711.png)
![](https://img-home.csdnimg.cn/images/20220527035711.png)
![](https://img-home.csdnimg.cn/images/20220527035111.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![](https://csdnimg.cn/release/wenkucmsfe/public/img/green-success.6a4acb44.png)