INSTANCE和DATABASE
SGA和PGA
SGA和DATABASE
Server process和Background process
SGA和Background process
第1题:
简述SGA主要组成结构和用途?
第2题:
A. INSTANCE和DATABASE
B. SGA和PGA
C. SGA和DATABASE
D. Server process和Background process
E. SGA和Background process
第3题:
TheDBAhaschosentomanageSGAandPGAmemoryseparatelyinanOLTPdatabasebecauseofhisuniqueknowledgeoftheapplication.WhichofthesearegoodstartingpointstousewhenconfiguringthemaximumvaluesforSGAandPGA,basedontheamountofmemoryavailableonthesystem?()
A.20%SGA 80%PGA
B.25%SGA 75%PGA
C.50%SGA 50%PGA
D.75%SGA 25%PGA
E.80%SGA 20%PGA
第4题:
Oracle数据库的例程由()组成。
第5题:
Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?()
第6题:
A. Shared pool和Server process
B. Shared pool和Background process
C. SGA和user process
D. PGA和user process
E. SGA和Background process
第7题:
Oracle数据库服务器是由()组成。(oracle数据库用于存储和检索信息,是数据的集合,包括逻辑结构和物理结构。Oracle例程是指数据库服务器的内存和相关处理程序)
第8题:
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
第9题:
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?()
第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?()