Oracle Instance由哪两个部分组成?()
第1题:
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
第2题:
A. INSTANCE和DATABASE
B. SGA和PGA
C. SGA和DATABASE
D. Server process和Background process
E. SGA和Background process
第3题:
A.DB_CACHE_SIZE
B.SHARED_POOL_SIZE
C.LARGE_POOL_SIZE
D.JAVA_POOL_SIZE
E.SGA_MAX_SIZE
F.SORT_AREA_SIZE
第4题:
Which Oracle background process frees SGA resources that were allocated to a user process that failed?()
第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?()
第6题:
A. Shared pool和Server process
B. Shared pool和Background process
C. SGA和user process
D. PGA和user process
E. SGA和Background process
第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?()
第8题:
A.DB_CACHE_SIZE
B.SHARED_POOL_SIZE
C.LARGE_POOL_SIZE
D.JAVA_POOL_SIZE
E.SGA_MAX_SIZE
F.SORT_AREA_SIZE
第9题:
在ORACLE10G中,()参数的调整需要重启数据库才能生效。
第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? ()