1Z0-053 V13.03修正版：确保IT考试通过的权威指南

需积分: 9 129 浏览量更新于2024-07-22 收藏 3.1MB PDF 举报

"这是一份针对OCP考试1Z0-053的复习资料，版本为V13.03，专为Oracle Database 11g Administration II设计，旨在帮助考生通过IT认证考试。该书籍特别强调了对于网络上发布可能存在的错误答案进行了修正，高亮标注，以确保学习者获得准确的信息。在书中，第1部分讨论了在部署新应用模块时，软件供应商会随新引入的SQL语句提供相应的SQL计划基线，选项A和C描述了其后果：计划基线可以随着时间优化性能，而新生成的计划会直接使用已知性能良好的现有策略执行，直到经过验证。选项B提到新SQL不会未经验证就直接加入基线，D则指出，导入基线后，优化器不会为已有基线的SQL语句生成新的计划。在第2部分中，涉及到了默认系统定义的移动窗口基线（Moving Window Baseline）的调整。考生需要考虑增大移动窗口大小以使用适应性阈值，这意味着在增加窗口大小时，需要考虑的因素包括对性能的影响以及如何根据适应性策略来调整，以满足特定的需求和目标。这份修正版教材不仅提供了题目，还包含了对答案的解析和策略指导，对准备1Z0-053考试的学生来说，它是一个重要的备考工具，能够帮助他们避免因错误信息而走弯路，提高通过率。"

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

15 / 193

D. The pending area has not been created before running the I/O calibration process.

Answer: B

49.Which statement about recovering from the loss of a redo log group is true?

A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.

B. If the lost redo log group is CURRENT, you must clear the log file.

C. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and

open the database using the RESETLOGS option.

D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery,

and open the database using the RESETLOGS option.

Answer: D

50.Examine the following command:

ALTER DISKGROUP data MOUNT FORCE;

In which scenario can you use the above command to mount the disk group?

A. when ASM disk goes offline

B. when one or more ASM files are dropped

C. when some disks in a disk group are offline

D. when some disks in a failure group for a disk group are rebalancing

Answer: C

51.To control the execution of a server process when it is receiving bad packets from a potentially

malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as

follows:

SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;

What is the significance of this setting?

A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same

instance.

B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt

the same operation again.

C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot

reconnect to the same instance.

D. It terminates the client connection after receiving a bad packet and the client can reconnect to the

same instance after 10 minutes.

Answer: B

52.You have the following requirements in relation to the detection of block corruption for your database

instance:

Check for logical self-consistency of data blocks when modified in memory.

Checksums are calculated before and after the block change.

Checks are performed for the lost writes to the physical standby database.

Which method would help you perform the above checks automatically?

A. Set the DB_SECUREFILE parameter to PERMITTED.

B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.

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.

剩余193页未读，继续阅读

tramp

粉丝: 0
资源: 3

1Z0-053 V13.03修正版：确保IT考试通过的权威指南

calendar-core-13.03-beta.jar

calendar-api-13.03-beta.jar

卡方检验4行3列，第一行 10，5，2，第二行 55，28，6 第三行 28 30，7 第四行 12，11，8，卡方值和p值是多少

毕业设计论文Nodejs+Vue宠物店管理系统.docx

（自适应手机版）响应式化工工业企业模板_网站整站打包下载.zip

金蝶与C#对接操作手册.doc

毕业设计论文Django+Vue应届生求职系统.docx

idea插件之Fast-Request-API-Buddy-2024.1.7.1

包含 10 个不同奧运会项目的 1000 张标记图像数据集

最新资源