2019年3月1Z0-053 OCP题库更新：高效通关策略

需积分: 10 51 浏览量更新于2024-07-17 1 收藏 3.59MB PDF 举报

身份认证购VIP最低享 7 折!

30元优惠券

资源详情

资源推荐

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.

剩余209页未读，继续阅读

informantion518

粉丝: 1
资源: 4

2019年3月1Z0-053 OCP题库更新：高效通关策略

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

oracle ocp 053题库

oracle ocp 053

老哥讲数据库mysql ocp 8.0 1z0-908题库

mysql 8 ocp 1z0-908 题库

mysql ocp 8.0 1z0-908 报名流程

java 1z0-809

mysql8.0 ocp题库

mysql5.7 ocp题库

oracle ocp 19c

oracle 12c OCP

如何将ocp镜像密钥复制到${OCP_PATH}/secret/redhat-secret.json

oracle ocp

helm 部署时候有些配置是： cognitiveservices.net/gateway-timeout: "234" cognitiveservices.net/gateway-retry-timeout: "123" cognitiveservices.net/gateway-retry: "1" 这些配置都有什么作用，用curl命令怎么测试这些配置是否生效？

OCP的NCSI功能

ocp 计算器程序设计画出类图

ocp nic 3.0 spec

oc adm release info "quay.io/${PRODUCT_REPO}/${RELEASE_NAME}:${OCP_VER}-x86_64"

OCA/OCP/OCM

ocp3.0 pcie 区别

最新资源