What is the parameter TINIT used for？（)

相似题目

• 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.

  查看最佳答案

• View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?（）https://assets.asklib.com/images/image2/2018080213555554170.png

  A . The COMMIT order in the captured workload is preserved during replay. B . The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls. C . The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured. D . The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying. E . The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

  查看最佳答案

• our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）

  A . The command succeeds only if Automatic Memory Management is not enabled. B . The command succeeds， but you need to restart the database for changes to take effect. C . The command returns an error because the size of the redo log buffer cannot be changed dynamically. D . The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）

  查看最佳答案

• Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH；  What would be the outcome of this command？ （）

  A . The command would return an error because LOG_BUFFER is a static parameter. B . The parameter value would be changed and it would come into effect immediately. C . You need to restart the database so that parameter changes can come into effect. D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

  查看最佳答案

• Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）

  A . The Advisory is on and will capture both CPU and memory overhead. B . The Advisory is on but the memory for the Advisory is not allocated. C . The Advisory is off and the memory for the Advisory is not allocated. D . The Advisory is off but the memory for the Advisory remains allocated.

  查看最佳答案

• What is the maximum number of ARCn processes that can be defined using the initialization parameter LOG_ARCHIVE_MAX_PROCESSES？（）

  A . 1 B . 5 C . 10 D . 15 E . Depends on system memory resource

  查看最佳答案

• What is the name of the method that threads can use to pause their execution until signalled to continue by another thread？ （） Fill in the name of the method （do not include a parameter list）.

  查看最佳答案

• If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）

  A . All sorts will be done in a temporary table space.   B . The shared sort memory allocation will be calculated by DB2 C . No shared memory is allocated for sorting.   D . All sorts will be done in shared memory.

  查看最佳答案

• You are trying to change the polling parameters used by the location manager via the Cisco WCS，and your request is being denied. What is wrong？（）

  A . Your login does not have the correct permissions. B . You must wait for the location server to become available. C . Polling values can be changed only on the location server. D . Polling values can be changed only in the maintenance window.

  查看最佳答案

• You are trying to change the polling parameters used by the location manager via the Cisco WCS，and your request is being denied. What is wrong？（）

  A . Polling values can be changed only in the maintenance window. B . Polling values can be changed only on the location server. C . Your login does not have the correct permissions. D . You must wait for the location server to become available.

  查看最佳答案

• Given a method that must ensure that its parameter is not null： https://assets.asklib.com/images/image2/2018080116145077624.png What， inserted at line 12， is the appropriate way to handle a null value？（）

  A . assert value == null； B . assert value != null， "value is null"； C . if （value == null） { throw new AssertionException（"value is null"）； } D . if （value == null） { throw new IllegalArgumentException（"value is null"）； }

  查看最佳答案

• What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation？（）  

  A .  The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time. B .  The ASM rebalance operation will consume fewer resources and complete in a longer amount of time. C .  The ASM rebalance operation will be parallelized and should complete in a shorter amount of time. D .  There is no ASM_POWER_LIMIT setting used in ASM. E .  None of the above.

  查看最佳答案

• Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）

  A . The command would return an error because LOG_BUFFER is a static parameter. B . The parameter value would be changed and it would come into effect immediately. C . You need to restart the database so that parameter changes can come into effect. D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

  查看最佳答案

• What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?（）

  A . The number of DBWR processes increases B . The number of ASMB processes increases C . The number of DBWR_TO_SLAVES increases D . The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

  查看最佳答案

• Given a method that must ensure that its parameter is not null： https://assets.asklib.com/images/image2/2018080115050428991.jpg What， inserted at line 12， is the appropriate way to handle a null value？（）

  A . assert value == null； B . assert value != null ： "value is null"； C . if （value == null）{    throw new AssertionException（"value is null"）；   } D . if （value == null）{    throw new IllegalArgumentException（"value is null"）；   }

  查看最佳答案

• You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting？ （） 

  A .  The trace files will be disabled only for a specific session. B .  Tracing will be disabled for a client identifier. C .  Tracing will be disabled only for the ARCn process. D .  The SQL Trace facility will be disabled for the instance.

  查看最佳答案

• 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.

  查看最佳答案

• After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME， the information in the control file is overwritten by RMAN. What is this parameter’s default value？（）

  A . 1 day B . 5 days C . 7 days D . 31 day

  查看最佳答案

• In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What isthe impact of this setting（）

  A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

  查看最佳答案

• in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting（）

  A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

  查看最佳答案

• You are trying to change the polling parameters used by the location manager via the Cisco WCS， and yourrequest is being denied. What is wrong？（）

  A . Your login does not have the correct permissions. B . You must wait for the location server to become available. C . Polling values can be changed only on the location server. D . Polling values can be changed only in the maintenance window.

  查看最佳答案

• Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）

  A . The command succeeds only if Automatic Memory Management is not enabled. B . The command succeeds， but you need to restart the database for changes to take effect. C . The command returns an error because the size of the redo log buffer cannot be changed dynamically. D . The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

  查看最佳答案

• You are trying to change the polling parameters used by the location manager via the cisco wcs， and your request is being denied. What is wrong？（）

  A . polling values can be changed only in the maintenance window. B . polling values can be changed only on the location server. C . your login does not have the correct permissions. D . you must wait for the location server to become available.

  查看最佳答案

• The purpose of ramping is to avoid handover decisions to a new neighbor based on only a few samples. What is a common parameter setting for macro cells？()

  A.SSRAMPSI=10 and SSRAMPSD=20 B.SSRAMPSI=10 and SSRAMPSD=10 C.SSRAMPSI=5 and SSRAMPSD=2 D.SSRAMPSI=2 and SSRAMPSD=5

  查看最佳答案