单选题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

题目
单选题
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

120M

B

320M

C

480M

D

600M

相似考题

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

2.View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?()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.

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

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

更多“单选题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”相关问题

  • 第1题：

    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.120M

    B.320M

    C.480M

    D.600M


    参考答案：D

  • 第2题：

    Click the Exhibit button.When configuring WXC A‘s local WAN parameters, which QoS network parameter would you choose?()

    A. over-subscribed

    B. under-subscribed

    C. dedicated circuits

    D. nondedicated circuits


    参考答案：C

  • 第3题：

    You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_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_SIZE
    • B、The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
    • C、The database instance starts, but Automatic Memory Management is disabled
    • D、The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

    正确答案:B

  • 第4题：

    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 BASIC
    • B、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
    • C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
    • D、The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
    • E、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

    正确答案:A

  • 第5题：

    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、120M
    • B、320M
    • C、480M
    • D、600M

    正确答案:D

  • 第6题：

    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 days

    正确答案:B

  • 第7题：

    Your network contains a server named Server1 that runs Windows Server 2008 R2. Server1 is located in a branch office. You view the BranchCache configuration of Server1 as shown in the exhibit. (Click the Exhibit button.) You need to ensure that client computers in the branch office retrieve cached files from Server1 only. What should you do on Server1?（）

    • A、Install the BranchCache for Network Files role service
    • B、Install the Services for Network File System role service
    • C、Run netsh.exe branchcache set service mode=DISTRIBUTED
    • D、Run netsh.exe branchcache set service mode=HOSTEDSERVER

    正确答案:D

  • 第8题：

    单选题
    Click the Exhibit button. When configuring WXC A's local WAN parameters, which QoS network parameter would you choose?（）
    A

    over-subscribed

    B

    under-subscribed

    C

    dedicated circuits

    D

    nondedicated circuits


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    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

    120M

    B

    320M

    C

    480M

    D

    600M


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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_SIZE

    B

    The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

    C

    The database instance starts, but Automatic Memory Management is disabled

    D

    The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    Your network contains a server named Server1 that runs Windows Server 2008 R2. Server1 is located in a branch office. You view the BranchCache configuration of Server1 as shown in the exhibit. (Click the Exhibit button.) You need to ensure that client computers in the branch office retrieve cached files from Server1 only. What should you do on Server1?（）
    A

    Install the BranchCache for Network Files role service

    B

    Install the Services for Network File System role service

    C

    Run netsh.exe branchcache set service mode=DISTRIBUTED

    D

    Run netsh.exe branchcache set service mode=HOSTEDSERVER


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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_SIZE

    B

     The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA

    C

     The database instance starts，but Automatic Memory Management is disabled

    D

     The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter


    正确答案： A
    解析： 暂无解析

  • 第13题：

    View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()

    A. 90 MB

    B. 272 MB

    C. 362 MB

    D. 1,440 MB


    参考答案：C

  • 第14题：

    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_SIZE
    • B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
    • C、 The database instance starts，but Automatic Memory Management is disabled
    • D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

    正确答案:B

  • 第15题：

    Which statement about Automatic Memory Management with Oracle 11g is true？（）  

    • A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.
    • B、 Oracle can reallocate memory between the SGA and PGA automatically as needed.
    • C、 To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
    • D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

    正确答案:B

  • 第16题：

    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

    • A、Set MEMORY_TARGET to zero
    • B、Set the STATISTICS_LEVEL parameter to BASIC
    • C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
    • D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

    正确答案:D

  • 第17题：

    You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）

    • A、The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
    • B、The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
    • C、The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
    • D、The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively

    正确答案:A,D

  • 第18题：

    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.

    正确答案:A

  • 第19题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    Which statement about Automatic Memory Management with Oracle 11g is true？（）
    A

     You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.

    B

     Oracle can reallocate memory between the SGA and PGA automatically as needed.

    C

     To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

    D

     You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）
    A

     Set MEMORY_TARGET to zero

    B

     Set the STATISTICS_LEVEL parameter to BASIC

    C

     Set the WORKAREA_SIZE_POLICY parameter to MANUAL

    D

     Set the PGA_AGGREGATE_TARGET parameter to nonzero value


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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 BASIC

    B

    The PGA_AGGREGATE_TARGET initialization parameter is set to zero.

    C

    The SGA_MAX_SIZE initialization parameter is set to less than 20 GB

    D

    The DB_CACHE_SIZE initialization parameter is set to less than 5 GB

    E

    The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    Which statement about Automatic Memory Management with Oracle 11g is true?（）
    A

    You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

    B

    Oracle can reallocate memory between the SGA and PGA automatically as needed.

    C

    To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

    D

    You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size


    正确答案： B
    解析： 暂无解析

相关内容