网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）
A
The User Global Area （UGA） is not configured.
B
The sessions were started using the login name SYS.
C
The sessions are running in the Automatic Shared Memory Management mode.
D
The sessions are running in the automatic Program Global Area （PGA） memory management mode.
参考答案
参考解析
解析：
暂无解析
更多 “单选题SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）A The User Global Area （UGA） is not configured.B The sessions were started using the login name SYS.C The sessions are running in the Automatic Shared Memory Management mode.D The sessions are running in the automatic Program Global Area （PGA） memory management mode.” 相关考题
考题
Which two initialization parameters would you set to enable Automatic Shared Memory Management?()
A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALL
考题
Note the following parameters settings in your database:What would happen?()
A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamicallyB. It will be successful only if the memory is available from the auto tuned componentsC. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETD. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
考题
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi－section backup.()
A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;D. BACKUP TABLESPACE TEMP SECTION SIZE 10M;E. BACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;F. BACKUP SPFILE SECTION SIZE 1M;G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
考题
Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）A. LOG_BUFFERB. SORT_AREA_SIZEC. JAVA_POOL_SIZED. STREAMS_POOL_SIZEE. DB_16K_CACHE_SZIEF. DB_KEEP_CACHE_SIZE
考题
Which of the following ping parameters will set the size of the outgoing packet?（）A、–cB、iC、RD、–s
考题
Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）A、 set SHARED_POOL_SIZE to zeroB、 set STATISTICS_LEVEL to BASICC、 set SGA_TARGET to a non-zero valueD、 set DB_CACHE_SIZE to a non-zero valueE、 set STATISTICS_LEVEL to TYPICAL or ALL
考题
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）A、The User Global Area （UGA） is not configured.B、The sessions were started using the login name SYS.C、The sessions are running in the Automatic Shared Memory Management mode.D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.
考题
You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）： SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G. What is the total PGA memory allocated across all database server processes？（） A、 10MB、 400MC、 600MD、 800M
考题
You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）A、 LARGE_POOL_SIZEB、 DB_CREATE_FILE_DESTC、 LOG_ARCHIVE_DESTD、 CONTROL_FILESE、 LOG_ARCHIVE_FORMATF、 DB_BLOCK_SIZE
考题
多选题Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）ALOG_BUFFERBSORT_AREA_SIZECJAVA_POOL_SIZEDSTREAMS_POOL_SIZEEDB_16K_CACHE_SZIEFDB_KEEP_CACHE_SIZE
考题
单选题You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）A
LARGE_POOL_SIZEB
DB_CREATE_FILE_DESTC
LOG_ARCHIVE_DESTD
CONTROL_FILESE
LOG_ARCHIVE_FORMATF
DB_BLOCK_SIZE
考题
多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE
考题
单选题You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）： SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G. What is the total PGA memory allocated across all database server processes？（）A
10MB
400MC
600MD
800M
考题
单选题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 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 set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement： SQL SELECT name， value， isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’； The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply？（）AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
考题
单选题You have included the following parameter setting in your server parameter file： PGA_AGGREGATE_TARGET = 800M SORT_AREA_SIZE = 100M HASH_AREA_SIZE = 100M BITMAP_MERGE_AREA_SIZE = 100M CREATE_BITMAP_AREA_SIZE = 100M Which statement is true？（）A
All the *_AREA_SIZE parameters are ignored.B
The Automatic PGA Memory Management feature cannot be disabled.C
The total Program Global Area （PGA） memory cannot be manually increased above 800M.D
The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.
考题
多选题The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;CBACKUP ARCHIVELOG ALL SECTION SIZE 25M;DBACKUP TABLESPACE TEMP SECTION SIZE 10M;EBACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;FBACKUP SPFILE SECTION SIZE 1M;GBACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
考题
单选题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 want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）A
DB_BLOCK_SIZEB
CONTROL_FILESC
LARGE_POOL_SIZED
LOG_ARCHIVE_DESTE
LOG_ARCHIVE_FORMATF
DB_CREATE_FILE_DEST
考题
多选题Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）Aset SHARED_POOL_SIZE to zeroBset STATISTICS_LEVEL to BASICCset SGA_TARGET to a non-zero valueDset DB_CACHE_SIZE to a non-zero valueEset STATISTICS_LEVEL to TYPICAL or ALL
考题
单选题In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A
when the data file of the undo tablespace is autoextensibleB
when there are more than one undo tablespaces available in the databaseC
when the undo tablespace is of a fixed size and retention guarantee is not enabledD
when the undo tablespace is autoextensible and retention guarantee is not enabled
考题
单选题In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A
When the data file of the undo tablespace is autoextensibleB
When there are more than one undo tablespaces available in the databaseC
When the undo tablespace is of a fixed size and retention guarantee is not enabledD
When the undo tablespace is autoextensible and retention guarantee is not enabled
考题
多选题Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）ATARGET_REDO_BLKSBFAST_START_IO_TARGETCLOG_CHECKPOINT_TIMEOUTDRECOVERY_ESTIMATED_IOSELOG_FILE_SIZE_REDO_BLKSFLOG_CHECKPOINT_INTERVAL
考题
单选题Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）A
It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamicallyB
It will be successful only if the memory is available from the auto tuned componentsC
It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETD
It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
考题
单选题SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）A
The User Global Area （UGA） is not configured.B
The sessions were started using the login name SYS.C
The sessions are running in the Automatic Shared Memory Management mode.D
The sessions are running in the automatic Program Global Area （PGA） memory management mode.
考题
多选题Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）ALOG_BUFFERBSORT_AREA_SIZECJAVA_POOL_SIZEDSTREAMS_POOL_SIZEEDB_16K_CACHE_SZIEFDB_KEEP_CACHE_SIZE
考题
单选题Which of the following ping parameters will set the size of the outgoing packet?（）A
–cB
iC
RD
–s
热门标签
最新试卷
