单选题When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（）   "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 ExamADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZ

题目
单选题
When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（）   "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 Exam
A

 DB_CACHE_SIZE

B

 SHARED_POOL_SIZE

C

 LARGE_POOL_SIZE

D

 JAVA_POOL_SIZE

E

 SGA_MAX_SIZE

F

 SORT_AREA_SIZE

相似考题

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

2.Which of the following should be done FIRST when troubleshooting a problem？（）A、Test the theory to determine the causeB、Perform a root cause analysisC、Establish a plan of actionD、Document outcomes

3.Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE

4.To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL > startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.（）A.The PGA_AGGREGATE_TARGET parameter is set to zero.B.The STATISTICS_LEVEL parameter is setto basic.C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.

更多“单选题When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（）   "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 ExamA  DB_CACHE_SIZEB  SHARED_POOL_SIZEC  LARGE_POOL_SIZED  JAVA_”相关问题

  • 第1题：

    A customer states their computer was fine until yesterday when they heard a pop noise and thecomputer stopped working. Which of the following components should the technician test FIRST?（）

    • A、Main system board
    • B、Processor
    • C、Hard disk drive
    • D、Power supply

    正确答案:D

  • 第2题：

    首过效应（first pass effect）


    正确答案:药物吸收通过胃肠道粘膜时可能被粘膜中的酶代谢，进入肝后，可能被生物转化。这种在吸收过程和吸收后进入肝转运至体循环过程中，部分药物被代谢，使进入体循环的原型药物量减少的现象，称为“首过代谢”或“首过效应”。

  • 第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_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题：

    To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）

    • A、 DB_CACHE_SIZE
    • B、 SHARED_POOL_SIZE
    • C、 LARGE_POOL_SIZE
    • D、 JAVA_POOL_SIZE
    • E、 SGA_MAX_SIZE
    • F、 SORT_AREA_SIZE

    正确答案:A,B,C,D

  • 第5题：

    When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（）   "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 Exam

    • A、 DB_CACHE_SIZE
    • B、 SHARED_POOL_SIZE
    • C、 LARGE_POOL_SIZE
    • D、 JAVA_POOL_SIZE
    • E、 SGA_MAX_SIZE
    • F、 SORT_AREA_SIZE

    正确答案:E

  • 第6题：

    In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  

    • A、 Setting a nonzero value for SGA_TARGET
    • B、 Configuring Automatic Shared Memory Management
    • C、 Configuring Automatic Memory Management
    • D、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
    • E、 None of the above

    正确答案:B

  • 第7题：

    单选题
    In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）
    A

     Setting a nonzero value for SGA_TARGET

    B

     Configuring Automatic Shared Memory Management

    C

     Configuring Automatic Memory Management

    D

     Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

    E

     None of the above


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

  • 第8题：

    名词解释题
    首过效应（first pass effect）

    正确答案： 药物吸收通过胃肠道粘膜时可能被粘膜中的酶代谢，进入肝后，可能被生物转化。这种在吸收过程和吸收后进入肝转运至体循环过程中，部分药物被代谢，使进入体循环的原型药物量减少的现象，称为“首过代谢”或“首过效应”。
    解析： 暂无解析

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    多选题
    Which of the following are the FIRST actions to take when an administrator is troubleshooting a server？（）
    A

    Make one change at a time and test/confirm the change has resolved the problem.

    B

    Verify full system functionality.

    C

    Replicate the problem.

    D

    Determine if a common element is causing multiple problems.

    E

    Identify any changes to the server.


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

  • 第11题：

    单选题
    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


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

  • 第12题：

    单选题
    A customer states their computer was fine until yesterday when they heard a pop noise and thecomputer stopped working. Which of the following components should the technician test FIRST?（）
    A

    Main system board

    B

    Processor

    C

    Hard disk drive

    D

    Power supply


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

  • 第13题：

    首关消除（first-pass effect）


    正确答案:又称首过效应、首过消除、第一关卡效应，口服药物从胃肠道吸收入门静脉系统的药物在到达全身血循环前必先通过肝脏，如果肝脏对其代谢能力很强或由胆汁排泄的量很大，则使进入全身血循环内的有效药量明显减少，这种作用称为首关消除。

  • 第14题：

    Which of the following are the FIRST actions to take when an administrator is troubleshooting aserver?（）

    • A、Make one change at a time and test/confirm the change has resolved the problem.
    • B、Verify full system functionality.
    • C、Replicate the problem.
    • D、Determine if a common element is causing multiple problems.
    • E、Identify any changes to the server.

    正确答案:C,E

  • 第15题：

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

    正确答案:C

  • 第16题：

    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第17题：

    Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

    • A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
    • B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
    • C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
    • D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

    正确答案:A

  • 第18题：

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


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

  • 第19题：

    单选题
    Which of the following changes to sentence 7 would best improve the coherence of the first paragraph?
    A

    Change you to their children.

    B

    Change use to also use.

    C

    Begin the sentence with Nevertheless.

    D

    Begin the sentence with For instance.

    E

    Change to behave to behaving.


    正确答案： A
    解析：
    因为这段话主要谈论行为的大致趋势，讨论的主语和宾语应该采用第三人称，因此代词“you”不合适，应改为“their children”。

  • 第20题：

    单选题
    When installing an inkjet printer for the first time， which of the following should be done FIRST？ （）
    A

    Print a test page from the Printer icon under the printers tab.

    B

    Select the new printer as the default printer.

    C

    Run the printhead alignment within the Tools folder of the printer.

    D

    Ensure that the printer is set for bi-directional printing.


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

  • 第21题：

    单选题
    To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）
    A

    The PGA_AGGREGATE_TARGET parameter is set to zero.

    B

    The STATISTICS_LEVEL parameter is setto basic.

    C

    Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.

    D

    The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.


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

  • 第22题：

    单选题
    You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually.  Which action should you take to enable archiving at instance startup？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第23题：

    单选题
    When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）
    A

    Online 

    B

    Pending online 

    C

    Offline 

    D

    Stale


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

相关内容