Oracle数据库11g管理员II：2019年2月OCP考试题库

5星 · 超过95%的资源需积分: 6 59 浏览量更新于2024-07-17 3 收藏 3.24MB PDF 举报

"最新OCP053（2019年2月）是Oracle OCP认证考试的科目053，包含Oracle Database 11g: Administration II的相关内容，截至2019年2月的最新题库，版本V13.02。" 在Oracle数据库管理中，题库中的第一部分涉及SQL计划基线的使用。SQL计划基线是一种性能优化工具，用于存储已知能提供良好性能的执行计划。以下是关于SQL计划基线的两个关键知识点： 1. **SQL计划基线的部署与应用**： A. 计划基线可以随时间进化以改善性能：当新的应用程序模块被部署时，软件供应商可能会提供针对新SQL语句的预定义计划基线。这些基线能够随着时间的推移通过优化进一步提升性能。 C. 新的SQL语句最初会运行已知能产生良好性能的计划：在标准测试配置下，这些计划是经过验证的，确保新的SQL语句在启动时就能获得良好的执行性能。这有助于避免因新引入的SQL语句导致的性能问题。 2. **自适应阈值与移动窗口大小的调整**：当计划增大默认系统定义的移动窗口大小时，考虑因素之一是为了使用自适应阈值。自适应阈值是自动工作负载repository (AWR) 的一个特性，它允许数据库根据实际工作负载动态调整性能阈值。在增加移动窗口大小时，需要考虑以下关键点： - 收集级别对于AWR应设置为“BASIC”或更高：这是因为更高级别的收集级别会提供更多的性能数据，这对于自适应阈值功能来说是必要的，以便更准确地识别性能变化模式并作出相应的调整。这些知识点展示了Oracle数据库管理员在处理SQL性能优化和监控时需要掌握的核心概念。理解如何利用SQL计划基线来保证新SQL语句的性能，并知道如何调整AWR的移动窗口大小以支持自适应阈值，是Oracle Database 11g管理员必须具备的技能。这些技能将有助于确保数据库系统的稳定性和高性能。

The safer , easier way to help you pass any IT exams.

16 / 193

C. Set the DB_LOCK_CHECKSUM 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 algorithm 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 backups 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 any 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 result 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

The safer , easier way to help you pass any IT exams.

17 / 193

Answer: C

56.You discover that your Recycle Bin contains two tables with the 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 recovered 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_TABLE2 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 baselines.

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 ENABLE 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. creating jobs that will run automatically at a scheduled time

The safer , easier way to help you pass any IT exams.

18 / 193

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 following 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 convert 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 the 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 redo 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.

The safer , easier way to help you pass any IT exams.

20 / 193

70.You executed the following SQL statement to shrink the EMPLOYEES 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 the 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 possible 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 Segment 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 image 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

剩余211页未读，继续阅读

雨巷仁杰

粉丝: 0
资源: 2

Oracle数据库11g管理员II：2019年2月OCP考试题库

oracle ocp 053题库

ocp053稳过，本人5月5号已过

高亮(更新版） 1Z0-053（20190329 ） ocp 053 2019年3月最新题库

2019年最新OCP053通关整理真题(711+36+60),本人3月30号考试亲测分数80%,百分百通关

ocp-052最新题库-2019年3月最新

OCP 053最新题库

oracle ocp 2019年3月 最新 071题库 1z0-071(20190329)

2019年3月30日OCP考试资源

2019年4月最新053考试题库

2019年最新OCP052通关整理真题(合计252道题,完全版本),本人3月30号考试亲测分数86%,百分百通关

最新资源

oracle ocp 2019年3月最新 071题库 1z0-071(20190329)