网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（） The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set
- A、 then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，
- B、 then it is set to $ORACLE_HOME
- C、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOME
- D、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
参考答案
更多 “ Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（） The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set A、 then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，B、 then it is set to $ORACLE_HOMEC、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOMED、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE” 相关考题
考题
Given:Which two statements are true about the result if the default locale is Locale.US?()
A.The value of b is 2.B.The value of a is 3.14.C.The value of b is 2.00.D.The value of a is 3.141.E.The value of a is 3.1415.F.The value of a is 3.1416.G.The value of b is 2.0000.
考题
You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
考题
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC. The database instance starts, but Automatic Memory Management is disabledD. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?()
A.120MB.320MC.480MD.600M
考题
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL >CONNECT scott/tiger@orcl What could be the reason for this?（）A. The listener is not running on the database node.B. The TNS_ADMIN environment variable is set to the wrong value.C. The orcl.oracle.com database service is not registered with the listener.D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E. The listener is running on a different port.
考题
Refer to the exhibit. A company would prefer all Internet - bound OSPF routed traffic to use ISP ABC with ISP DEF as a backup. As the network consultant, what three configuration changes might you make?（）A. The default -information originate command should be configured on router B1 and B4.B. The default -information originate command should be configured on router B2 and B3.C. If the metric value for ISP ABC is set at the default, the I SP DEF metric value should be set to 1.D. If the metric value for ISP ABC is set at the default, the ISP DEF metric value should be set to 25.E. The metric type value should be set to type 1.F. The metric type value should be set to type 2.
考题
Which statements about the MEMORY_TARGET initialization parameter are true？（） A、 MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zeroB、 MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC、 MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D、 MEMORY_TARGET is static and cannot be modified without shutting down the instance
考题
Which three statements are true about the voice VLAN feature on a Catalyst 2950 switch？ （Choose three.）（） A、 The CoS value is trusted for 802.1p or 802.1q tagged traffic.B、 The voice VLAN feature is disabled by default.C、 The IP phone accepts the priority of all tagged and untagged traffic and sets the CoS value to 4.D、 When the voice VLAN feature is enabled， all untagged traffic is sent according to the default CoS priority of the port.E、 PortFast is automatically disabled when a voice VLAN is configured.F、 The default CoS value for incoming traffic is set to 0.
考题
On a newly installed AIX V4 machine, which of the following default values applies to the ipforwarding network option?（）A、 The ipforwarding is off by default. B、 The ipforwarding is set on by default. C、 The value is dynamically determined at boot time by DHCP. D、 The value is equal to the setting of the directed_broadcast runtime attribute.
考题
Which two statements are true regarding the SGA_TARGET initialization parameter（）A、It can be increased up to the value of the SGA_MAX_SIZE parameter.B、Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.C、Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.D、Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
考题
You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true？（）A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、 The database instance starts，but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）A、The installation terminates with an error.B、The installation proceeds with the default value without warnings and errors.C、The installation proceeds with the default value but it would not be an OFA-compliant database.D、The installation proceeds with the default value but a message would be generated in the alert log file.
考题
Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）A、The MTTR advisor will be disabled.B、Automatic checkpoint tuning will be enabled.C、The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.D、The time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization 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
考题
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.
考题
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
考题
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL CONNECT scott/tiger@orcl What could be the reason for this?（）A、The listener is not running on the database node.B、The TNS_ADMIN environment variable is set to the wrong value.C、The orcl.oracle.com database service is not registered with the listener.D、The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E、The listener is running on a different port.
考题
Examine the following values of the initialization parameters in the database having the SID ORCL： BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value： ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository （ADR） home？（）A、 /u01/app/oracle/product/11.1.0/db_1B、 /u01/app/oracleC、 $ORACLE_HOME/bdumpD、 $ORACLE_HOME/log
考题
You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.
考题
单选题What could be the reason for this（）A
The listener is not running on the database node.B
The TNS_ADMIN environmental variable is set to a wrong value.C
The orcl.oracle.com database service is not registered with the listener.D
The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.
考题
多选题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
考题
单选题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 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
考题
单选题During the installation of Oracle Database 11g，you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation？（）A
The installation terminates with an error.B
The installation proceeds with the default value without warnings and errors.C
The installation proceeds with the default value but it would not be an OFA-compliant database.D
The installation proceeds with the default value but a message would be generated in the alert log file.
考题
单选题Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（） The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t setA
then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，B
then it is set to $ORACLE_HOMEC
DIAGNOSTIC_DEST is always equal to $ORACLE_HOMED
DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
考题
多选题Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）AThe MTTR advisor will be disabled.BAutomatic checkpoint tuning will be enabled.CThe value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.DThe time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.
考题
单选题On a newly installed AIX V4 machine, which of the following default values applies to the ipforwarding network option?（）A
The ipforwarding is off by default. B
The ipforwarding is set on by default. C
The value is dynamically determined at boot time by DHCP. D
The value is equal to the setting of the directed_broadcast runtime attribute.
热门标签
最新试卷