网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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
考题
You are the administrator of Ezonexam.com's network.You want to connect your Windows 2000 Professional computer to a new TCP/IP based laser print device. The print device is Plug and Play compliant and is included on the current Hardware Compatibility List (HCL). When you attempt to create a new TCP/IP printer port you receive the following error message:"Specified Port cannot be added. The port already exists."You want to be able to use the new TCP/IP printer.What should you do?A．Modify the properties of the existing printer port to use the new print device.B．Change the LPT port setting to bidirectional in the BIOS on your computer.C．Change the LPT port setting to enable legacy Plug and Play detection on your computer.D．Obtain and install the WDM-compliant device drivers and printing software for the printer.
考题
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）A、to enable the ASM instance to identify the alert log fileB、to enable the ASM instance to identify the server parameter fileC、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
考题
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.
考题
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）A、Data blocks have to be written more frequently by DBWR. B、Redo blocks have to be written more frequently by LGWR. C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
考题
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
考题
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）A、 DATEB、 TIMESTAMPC、 INTERVAL YEAR TO MONTHD、 INTERVAL DAY TO SECONDE、 TIMESTAMP WITH LOCAL TIME ZONE
考题
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 are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A、 Only data blocks of the SYSTEM tablespace will be checked.B、 Only data blocks of the SYSAUX tablespace will be checked.C、 A checksum will occur only on the checkpoint.D、 A checksum will occur every time a block is modified.
考题
You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A、 only the INSTANCE_TYPE initialization parameter is set to an invalid valueB、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
考题
You are the administrator of Company's network. You wish to connect your Windows 2000 Professional computer to a new TCP/IP based Plug and Play compliant print device. The print device is included on the current Hardware Compatibility List (HCL) When you attempt to create a new TCP/IP printer port, you receive the following message: "Specified Port cannot be added. The port already exists." You want to create a new TCP/IP printer port. What should you do? （）A、Change the LPT port setting to enable legacy Plug and Play detection on your computer.B、Delete the existing printer port.C、Change the LPT port setting to bidirectional in the BIOS on your computer.D、Obtain and install the WDM-compliant device drivers and printing software for the printer.
考题
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A
to enable operating system authentication for a remote clientB
to restrict the scope of administration to identical operating systemsC
to allow the start up and shut down of the database from a remote clientD
to enable the administration of the operating system from a remote clientE
to disable the administration of the operating system from a remote client
考题
单选题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
考题
单选题You have the following requirements in relation to the detection of block corruption for your database instance: 1. Check for logical self-consistency of data blocks when modified in memory. 2. Checksums are calculated before and after the block change. 3. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically? （）A
Set the DB_SECUREFILE parameter to PERMITTEDB
Set the DB_ULTRA_SAFE parameter to DATA_ONLYC
Set the DB_LOCK_CHECKSUM parameter to TYPICALD
Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
考题
多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE
考题
单选题In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated. How do you achieve this objective？（）A
by setting the SQL_TRACE parameter to FALSE in the parameter fileB
by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionC
by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionD
by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
考题
单选题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.
考题
多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY/x7fMM/x7fDD. The default format of which two data types would be affected by this setting？（）ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE
考题
单选题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
考题
单选题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 8GB
The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2GC
The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2GD
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
考题
单选题You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A
only the INSTANCE_TYPE initialization parameter is set to an invalid valueB
only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC
only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD
both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）A
to enable the ASM instance to identify the alert log fileB
to enable the ASM instance to identify the server parameter fileC
to enable the ASM instance to define the locations for Oracle Managed Files （OMF）D
to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
考题
单选题You have the following requirements in relation to the detection of block corruption for your database instance： Check for logical self-consistency of data blocks when modified in memory. Checksums are calculated before and after the block change. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically？（）A
Set the DB_SECUREFILE parameter to PERMITTEDB
Set the DB_ULTRA_SAFE parameter to DATA_ONLYC
Set the DB_LOCK_CHECKSUM parameter to TYPICALD
Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A
When a new log group is added， it would have one member in each disk group.B
When a new log group is added， it would have two members in each disk group.C
When a new tablespace is added， it would have one data file in each disk group.D
When a new log file is added， it would have one member spread across the disk groups.
考题
单选题You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A
Only data blocks of the SYSTEM tablespace will be checked.B
Only data blocks of the SYSAUX tablespace will be checked.C
A checksum will occur only on the checkpoint.D
A checksum will occur every time a block is modified.
考题
单选题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 （）him so closely; you should have kept your distance．A
shouldn’tfollowB
mustn’tfollowC
couldn’t have been followingD
shouldn’t have been following
热门标签
最新试卷
