移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed?()  

A

 Issue the ALTER DISKGROUP ... ADD DISK command.

B

 Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.

C

 Issue the ALTER DISKGROU

D

 Retrieve the disk from the Recycle Bin after the operation completes.

单选题 What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?()

A

The number of DBWR processes increases

B

The number of ASMB processes increases

C

The number of DBWR_TO_SLAVES increases

D

The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

单选题 Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()  

A

 New channels for restore and recovery tasks

B

 New name for the data files of the tablespace

C

 Auxiliary name for the data files of the tablespace

D

 Auxiliary destinations for an auxiliary set of data files

单选题 You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?()

A

Set metric threshold

B

Implement Database Resource Manager

C

Enable resumable timeout for user sessions

D

Add directives to Automatic Database Diagnostic Monitor (ADDM)

多选题 Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters?() 

A

 SORT_AREA_SIZE

B

 HASH_AREA_SIZE

C

 BITMAP_MERGE_AREA_SIZE

D

 CREATE_BITMAP_AREA_SIZE

E

 PGA_AGGREGATE_TARGET

多选题 Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.() (Choose all that apply.)

A

Backup retention policy

B

Default backup device type

C

Default destinations for backups

D

Multiple backup device types for single backup

E

Default section size for backups

单选题 You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()

A

 Enable the flash recovery area and specify it as the archived redo log destination.

B

 Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

C

 Enable the flash recovery area but do not specify it as the archived redo log destination. 

D

 Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

多选题 What is the purpose of the RMAN recovery catalog?() 

A

 It must be used because all RMAN-related backup and recovery metadata information is contained in it.

B

 It provides a convenient, optional, repository of backup- and recovery-related metadata.

C

 It provides the ability to store RMAN scripts for global use by any database that has access to the repository.

D

 It provides a means of storing all RMAN backup sets physically in an Oracle database server. 

E

 It provides the ability to store backup records for more than a year.

单选题 You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.  What is the correct action to achieve this?()  

A

 Create and populate a SQL Tuning Set from the AWR on every Monday.

B

 Change the RETENTION setting for the AWR snapshots to 7 days on Monday.

C

 Create a repeating baseline template.

D

 Insert a finding directive for future ADDM tasks.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第