移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 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

单选题 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.

单选题 From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users.   Which method would you use to achieve this objective?()

A

create a plan directive in the SYS_GROUP

B

create the pending area for the consumer group

C

activate the provided SYSTEM_PLAN in Resource Manager

D

set the TIMED_STATISTICS parameter to TRUE in the parameter file

E

set the execution time limit for all users, except SYS and SYSTEM, in their profiles

多选题 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

单选题 Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);

A

 to undo the changes made to the EMP table since the specified time

B

 to restore the EMP table that was wrongly dropped from the database

C

 to view the transactions that have modified the EMP table since the specified time

D

 to view the changes made to the EMP table for one or more rows since the specified time

多选题 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.

多选题 You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives:  Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4.   Consumer group MARKETwith CPU_P1as 20.   Consumer group DEVwith CPU_P1as 20.   Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100.  Which two statements are correct in this scenario?()

A

 The maximum degree of parallelism for the members of the consumer groups is 4.

B

 The CPU allocation will always be equal for the consumer groups MARKET and DEV.

C

 The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.

D

 The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.

E

 The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第