移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 While working on the database, you receive the following error:        01578: ORACLE data block corrupted (file# 6, block # 54)        ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery?()

A

 Block Media Recovery must be used with RMAN.

B

 You must perform complete recovery of individual blocks.

C

 You must have a full RMAN backup, not an incremental backup.

D

 You must use the DBVERIFY utility before using the Block Media Recovery feature.

单选题 While setting up the thresholds for tablespace space usage metrics for one of your tablespaces, you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting?()

A

It would result in an error because the warning threshold cannot be more than the critical threshold.

B

The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.

C

The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.

D

Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

单选题 You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you notice that the system identifier (SID) for the instance is set to ’+ASM’. What is the purpose of this instance?()

A

 This instance is being used to manage the operating system files.

B

 This instance is being used to manage the files of other databases.

C

 This instance is being used to manage the instances of other databases.

D

 This instance is being used to manage the background processes of other instances.

多选题 You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()

A

backup pieces

B

control file autobackups

C

copies of all the parameter files

D

trace file generated using BACKUP CONTROLFILE TO TRACE

单选题 You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter?()

A

The SGA_TARGET initialization parameter cannot be set to a value greater than 8G

B

 The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G

C

 The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G

D

 The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M 

E

 The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M

多选题 Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()

A

 You find that one of the redo log members in each redo log group is lost.

B

 You find that a data file that belongs to the USERS tablespace is damaged.

C

 You find that a data file that belongs to the SYSTEM tablespace is damaged.

D

 You find that the current redo log group is damaged and is not available for recovery.

E

 You realized while performing a recovery that an archived redo log file needed for recovery is lost.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第