Which statement about Automatic Memory Management with Oracle 11g is true?() A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate memory between the SGA and PGA automatically as needed.C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
Which statement about Automatic Memory Management with Oracle 11g is true?()
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
相关考题：
使用Windows性能监视器查找服务器的内存瓶颈,要跟踪()对象计数器。 A.Memory-page/secB.Memory-Page Faults/secC.Memory-pageread/secD.Memory-Cache Bytes
Which statements about the MEMORY_TARGET initialization parameter are true?() (Choose all that apply.) A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroB. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
Examine the commands executed to monitor database operations:$ conn sys oracle/oracle@prod as sysdbaSQL VAR eid NUMBERSQL EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING = ‘Y’);Which two statements are true?（）A. Database operations will be monitored only when they consume a significant amount of resource.B. Database operations for all sessions will be monitored.C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.D. Only DML and DDL statements will be monitored for the session.E. All subsequent statements in the session will be treated as one database operation and will be monitored.
Oracle中如何设置audittrail审计，正确的说法是：（）A、在init.ora文件中设置“audit_trail=true”或者“audit_trail=db”B、以SYSDBA身份使用AUDITALLONSYS.AUD$BYACCESS，语句对audittrail审计C、Oracle不支持对audittrail的审计D、在设置audittrail审计前，要保证已经打开Oracle的审计机制
如果想要配置Oracle以使用校验和来验证数据块,将初始化参数()设置为TRUE。 A.DB_BLOCKB.DB_EXTENT_CHECKSUMC.DB_BLOCK_CHECKSUMD.DB_SEQENT_CHECKSUM
The answers each list a tunnel method and two consecutive IPv6 address quartets.Which answers identify a tunneling method that relies on an IPv4 address to be embedded into an IPv6 address, within the correct quartets listed?（）A. Automatic 6to4, quartets 2 and 3B. Automatic 6to4, quartets 7 and 8C. ISATAP, quartets 2 and 3D. ISATAP, quartets 7 and 8
Which functionality is required within an IP router that is situated at the boundary of an IPv4 network and an IPv6 network to allow communication between IPv6－ only and IPv4 － only nodes?() A. AutoconfigurationB. Automatic 6to4 TunnelC. Automatic 6to4 RelayD. Network Address Translator - Protocol Translator (NAT - PT)E. Intrasite Automatic T unnel Address Protocol (ISATAP)
Refer to Topic TestKing.com in iPAD document.What happens to the network when TestKingX is reconnected and a trunk exists between the two switches?() A. All VLANs except the default VLAN will be removed from all switches.B. All existing switches will have the students, admin, faculty, Servers, Management,Production, and no-where VLANs.C. The VLANs Servers, Management, Production, and no-where will replace the VLANs on SwX.D. The VLANs Servers, Management, Production, and no-where will be removed from existing switches.
下列选项中，关于Statement描述错误的是（）A．Statement是用来执行SQL语句的B．Statement是PreparedStatement的子接口C．获取Statement实现需要使用Connection的createStatement()方法D．PreparedStatement能使用参数占位符，而Statement不行
下列选项中,关于Statement描述错误的是（)A．Statement是用来执行SQL语句的B．Statement是PreparedStatement的子接口C．获取Statement实现需要使用Connection的createStatement()方法D．PreparedStatement能使用参数占位符,而Statement不行