Oracle Instance由哪两个部分组成?()A、Shared pool和Server processB、Shared pool和Background processC、SGA和user processD、PGA和user processE、SGA和Background process

题目

Oracle Instance由哪两个部分组成?()

  • A、Shared pool和Server process
  • B、Shared pool和Background process
  • C、SGA和user process
  • D、PGA和user process
  • E、SGA和Background process
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()

A. User session data

B. Stack space

C. Private SQL area

D. Location of the runtime area for DML and DDL Statements

E. Location of a part of the runtime area for SELECT statements


参考答案:A, C

第2题:

Oracle Server由哪两个部分组成?()

A. INSTANCE和DATABASE

B. SGA和PGA

C. SGA和DATABASE

D. Server process和Background process

E. SGA和Background process


参考答案:A

第3题:

UsingOracleEnterpriseManagertosetSGApoolvaluesmanually,forwhichofthefollowingpoolsdoesOracleEMofferadvicetosetthevalueappropriately?()

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

第4题:

Which Oracle background process frees SGA resources that were allocated to a user process that failed?()

  • A、PMON
  • B、SMON
  • C、CKPT
  • D、LGWR
  • E、ARCn

正确答案:A

第5题:

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components?()  

  • A、 MMAN
  • B、 PMON
  • C、 MMON
  • D、 MMNL

正确答案:A

第6题:

Oracle Instance由哪两个部分组成?()

A. Shared pool和Server process

B. Shared pool和Background process

C. SGA和user process

D. PGA和user process

E. SGA和Background process


参考答案:E

第7题:

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_SIZE
  • B、 SHARED_POOL_SIZE
  • C、 LARGE_POOL_SIZE
  • D、 JAVA_POOL_SIZE
  • E、 SGA_MAX_SIZE
  • F、 SORT_AREA_SIZE

正确答案:A,B

第8题:

WhenmanuallyconfiguringtheSGA,whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect?()"FirstTest,FirstPass"-www.lead2pass.com97Oracle1Z0-053Exam

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

第9题:

在ORACLE10G中,()参数的调整需要重启数据库才能生效。

  • A、SGA_MAX_SIZE
  • B、SGA_TARGET
  • C、SHARED_POOL_SIZE
  • D、DB_CAHCHE_SIZE

正确答案:A

第10题:

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario? ()

  • A、 A total of 14 GB memory will be allocated to the automatically tuned memory components
  • B、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
  • C、 The value for SGA_TARGET can be increased up to a maximum of 14 GB
  • D、 A maximum of 3 GB can be allocated to shared pool
  • E、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
  • F、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

正确答案:C,E

更多相关问题