itgle.com

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

题目
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.

相似考题

1.使用Windows性能监视器查找服务器的内存瓶颈,要跟踪()对象计数器。A.Memory-page/secB.Memory-Page Faults/secC.Memory-pageread/secD.Memory-Cache Bytes

2.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.

3.Oracle中如何设置audittrail审计，正确的说法是：（）A、在init.ora文件中设置“audit_trail=true”或者“audit_trail=db”B、以SYSDBA身份使用AUDITALLONSYS.AUD$BYACCESS，语句对audittrail审计C、Oracle不支持对audittrail的审计D、在设置audittrail审计前，要保证已经打开Oracle的审计机制

4.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

更多“Which statement about Automatic Memory Management with Oracle 11g is true?() ”相关问题

  • 第1题：

    如果想要配置Oracle以使用校验和来验证数据块,将初始化参数()设置为TRUE。

    A.DB_BLOCK

    B.DB_EXTENT_CHECKSUM

    C.DB_BLOCK_CHECKSUM

    D.DB_SEQENT_CHECKSUM


    参考答案：C

  • 第2题：

    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. Autoconfiguration

    B. Automatic 6to4 Tunnel

    C. Automatic 6to4 Relay

    D. Network Address Translator - Protocol Translator (NAT - PT)

    E. Intrasite Automatic T unnel Address Protocol (ISATAP)


    参考答案：D

  • 第3题：

    下列选项中，关于Statement描述错误的是（）

    A．Statement是用来执行SQL语句的

    B．Statement是PreparedStatement的子接口

    C．获取Statement实现需要使用Connection的createStatement()方法

    D．PreparedStatement能使用参数占位符，而Statement不行


    Statement是PreparedStatement的子接口

  • 第4题：

    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 3

    B. Automatic 6to4, quartets 7 and 8

    C. ISATAP, quartets 2 and 3

    D. ISATAP, quartets 7 and 8


    参考答案：A, D

  • 第5题：

    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.


    参考答案：D

  • 第6题：

    下列选项中,关于Statement描述错误的是（)

    A．Statement是用来执行SQL语句的

    B．Statement是PreparedStatement的子接口

    C．获取Statement实现需要使用Connection的createStatement()方法

    D．PreparedStatement能使用参数占位符,而Statement不行


    Statement是PreparedStatement的子接口

相关内容