网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting?()
A

The optimizer statistics are collected automatically.

B

Only the timed operating system (OS) statistics and plan execution statistics are collected.

C

The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

D

The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. 

E

Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.


参考答案

参考解析
解析: 暂无解析
更多 “单选题In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting?()A The optimizer statistics are collected automatically.B Only the timed operating system (OS) statistics and plan execution statistics are collected.C The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.D The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. E Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.” 相关考题
考题 You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.

考题 A JSP page needs to set the property of a given JavaBean to a value that is calculated with the JSP page. Which three jsp:setProperty attributes must be used to perform this initialization?()A、IdB、ValC、NameD、ParamE、ValueF、Property

考题 You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting?()  A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start, and the undo segment will contain the undo data for at least one hour.D、 The database will start, and the undo segment will retain the undo data for at least 15 minutes.

考题 You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?()A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover (MTTR) would be increased.

考题 You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A、 0B、 1C、 NONED、 DEFAULT

考题 In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting?()A、The optimizer statistics are collected automatically.B、Only the timed operating system (OS) statistics and plan execution statistics are collected.C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.D、The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

考题 You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT

考题 单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value

考题 单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future.  What action would you take to achieve this task?()A Set the STATISTICS_LEVEL initialization parameter to ALL.B Create a baseline on a pair of snapshots that have the statistics of the peak­load period in the database.C Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.D Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid theautomatic purging of the snapshots.

考题 单选题You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A  Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B  Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C  Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D  Increase the value of the SGA_TARGET initialization parameter.

考题 单选题In your running instance, some of the initialization parameters are set as shown below: SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason?()A The STATISTICS_LEVEL initialization parameter is set to BASICB The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

考题 单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task?()A Set the STATISTICS_LEVEL initialization parameter to ALL.B Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.C Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.D Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid the automatic purging of the snapshots.

考题 单选题Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()A  modify the HASH_AREA_SIZE initialization parameterB  modify the PGA_AGGREGATE_TARGET initialization parameterC  modify the WORK_AREASIZE_POLICY initialization parameterD  increase the value of the SGA_TARGET initialization parameterE  increase the value of the SGA_MAX_SIZE initialization parameterF  increase the value of the SORT_AREA_SIZE initialization parameter

考题 单选题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting?()A  The database will not start.B  The database will start but will not retain the undo data in the undo segment.C  The database will start, and the undo segment will contain the undo data for at least one hour.D  The database will start, and the undo segment will retain the undo data for at least 15 minutes.

考题 单选题Your database is running in the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()A modify the HASH_AREA_SIZE initialization parameterB modify the PGA_AGGREGATE_TARGET initialization parameterC modify the WORK_AREASIZE_POLICY initialization parameterD increase the value of the SGA_TARGET initialization parameterE increase the value of the SGA_MAX_SIZE initialization parameterF increase the value of the SORT_AREA_SIZE initialization parameter

考题 单选题You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A  0B  1C  NONED  DEFAULT

考题 多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode, and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature? ()AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.

考题 单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task?()A  the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewB  the column of the V$INSTANCE_RECOVERY viewC  the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewD  the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

考题 单选题You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?()A The database performance would be enhanced.B The redo log files would be get filled more frequently.C The overall database performance would be degraded.D The mean time to recover (MTTR) would be increased.

考题 单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files?()A  Oracle Enterprise ManagerB  The V$LOG viewC  The V$LOGFILE viewD  The V$FLASHBACK_DATABASE_LOGS view

考题 单选题You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()A  INSTANCE_TYPEB  DB_UNIQUE_NAMEC  ASM_DISKSTRINGD  ASM_POWER_LIMIT

考题 单选题In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()A The optimizer statistics are collected automatically.B Only the timed operating system (OS) statistics and plan execution statistics are collected.C The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.D The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. E Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

考题 多选题You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective?()ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.