以下关于SGA和PGA的叙述正确的是（）..

第1题

[单选题] The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of memory available on the system？（）

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

点击查看答案

第2题

[单选题] Oracle Server由哪两个部分组成？（）

A、INSTANCE和DATABASE B、SGA和PGA C、SGA和DATABASE D、Server process和Background process E、SGA和Background process

点击查看答案

第3题

[单选题] 以下内存区不属于SGA的是（）。

A、数据库缓冲区高速缓存 B、PGA C、重做日志缓冲区 D、共享池

点击查看答案

第4题

[简答题] 说明数据库内存结构中SGA和PGA的组成，以及这两个内存区存放信息的区别。

点击查看答案

第5题

[单选题] Examine the parameter setting in your database: Which statement is correct about the database?（）

A、Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set B、The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set C、The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set D、Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

点击查看答案

第6题

[单选题] Examine the parameter setting in your database: Which statement is correct about the database?（）

A、Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set B、The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set C、The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set D、Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

点击查看答案

第7题

[] 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?（） 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、A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE B、B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA C、C. The database instance starts, but Automatic Memory Management is disabled D、D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

点击查看答案

第8题

[] Oracle Instance由哪两个部分组成？（） Oracle Instance由哪两个部分组成？（）

A、A. Shared pool和Server process B、B. Shared pool和Background process C、C. SGA和user process D、D. PGA和user process E、E. SGA和Background process

点击查看答案

第9题

[多选题] 以下关于以下关于底漆的叙述中，正确的是（）

A、硝基底漆为单组分底漆，主要包括硝化纤维和醇酸树脂 B、湿涂底漆的目的是为了防锈和提高漆多的附着力 C、洗涤底漆能够改善涂层的附着力和防锈性能 D、聚氨酯底漆的使用性能要比硝基底漆好底漆的叙述中

点击查看答案

以下关于SGA和PGA的叙述正确的是（）

请使用微信扫码支付