多选题Which statements are true regarding table compression? ()(Choose all that apply.)AIt saves disk space and reduces memory usage.BIt saves disk space but has no effect on memory usage.CIt incurs extra CPU overhead during DML as well as direct loading ope

题目
多选题
Which statements are true regarding table compression? ()(Choose all that apply.)
A

It saves disk space and reduces memory usage.

B

It saves disk space but has no effect on memory usage.

C

It incurs extra CPU overhead during DML as well as direct loading operations.

D

It incurs extra CPU overhead during DML but not direct loading operations.

E

It requires uncompress operation during I/O.


相似考题
更多“多选题Which statements are true regarding table compression? ()(Choose all that apply.)AIt saves disk space and reduces memory usage.BIt saves disk space but has no effect on memory usage.CIt incurs extra CPU overhead during DML as well as direct loading ope”相关问题
  • 第1题:

    Which system resources does WLM have the capability to control?()

    • A、 CPU, Memory and Network I/O 
    • B、 CPU, Memory and Disk I/O 
    • C、 CPU and Memory 
    • D、 CPU and Disk I/O

    正确答案:B

  • 第2题:

    Which of the following statements about declaration are true?()         

    • A、 Declaration of primitive types such as boolean, byte and so on does not allocate memory space for the variable.
    • B、 Declaration of primitive types such as boolean, byte and so on allocates memory space for the variable.
    • C、 Declaration of nonprimitive types such as String, Vector and so on does not allocate memory space for the object.
    • D、 Declaration of nonprimitive types such as String, Vector ans so on allocates memory space for the object.

    正确答案:A,D

  • 第3题:

    Which statement is true regarding the Junos OS?()

    • A、Each process runs in its own protected memory space ensuring that one process cannot directly interfere with another.
    • B、Processes share memory space but use separate ASICs so that one process cannot directly interfere with another.
    • C、A central processor called the IP2 Chip dynamically assigns memory as process needs fluctuate.
    • D、The memory management daemon (mmd) is responsible for allocating new memory for processes as they request it.

    正确答案:A

  • 第4题:

    Which statements are true regarding table compression?()

    • A、 It saves disk space and reduces memory usage.
    • B、 It saves disk space but has no effect on memory usage.
    • C、 It incurs extra CPU overhead during DML as well as direct loading operations.
    • D、 It incurs extra CPU overhead during DML but not direct loading operations.
    • E、 It requires uncompress operation during I/O.

    正确答案:A,C

  • 第5题:

    Which three statements are characteristic of the MEMORY storage engine?()

    • A、It can support transactions
    • B、Table contents are not saved if the server is restarted
    • C、It cannot contain text or BLOB columns
    • D、It can support foreign keys
    • E、Each table is represented on disk as an.frm file
    • F、Each table has a corresponding.MYI and .MYD file

    正确答案:B,C,E

  • 第6题:

    You have a computer that runs Windows XP Professional. The computer has the following hardware installed: 3 GB page file, 2. 4 GHz processor, 2 GB of physical memory, 20 GB hard disk that has 1 GB of free space You need to enable hibernation support on the computer. What should you do first?() 

    • A、Upgrade the processor.
    • B、Add additional physical memory.
    • C、Increase the size of the page file.
    • D、Create additional free hard disk space.

    正确答案:D

  • 第7题:

    多选题
    Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()
    A

    As ASM instance mounts an ASM control file

    B

    An ASM instance uses the ASMB process for rebalancing of disks within a disk group

    C

    Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

    D

    An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started


    正确答案: A,C
    解析: 暂无解析

  • 第8题:

    单选题
    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 zero

    B

    MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set

    C

    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


    正确答案: A
    解析: 暂无解析

  • 第9题:

    多选题
    Which of the following statements about declaration are true?()
    A

    Declaration of primitive types such as boolean, byte and so on does not allocate memory space for the variable.

    B

    Declaration of primitive types such as boolean, byte and so on allocates memory space for the variable.

    C

    Declaration of nonprimitive types such as String, Vector and so on does not allocate memory space for the object.

    D

    Declaration of nonprimitive types such as String, Vector ans so on allocates memory space for the object.


    正确答案: A,C
    解析: 对原始数据类型的变量的声明将为之分配内存并赋予一个缺省值,参见23题的叙述,而非原始数据类型的变量必须用new Xxxx()分配内存及初始化。但是严格来讲此题的答案有待确定,因为只有原始类型的实例变量和类变量的声明在类对象被创建/类被加载时完成内存的自动分配,而原始类型的局部变量必须显式初始化,从这点来看原始类型的局部变量没有被自动分配内存,SL275中只提出了非原始数据类型的变量必须使用new Xxxx()完成内存的分配而没有指出原始数据类型的变量是否在声明时即自动进行内存分配,而从局部变量不能在显式初始化前使用这点来看在声明时没有进行内存分配。因此答案a的正确性还有待官方的确定。

  • 第10题:

    单选题
    Which statement about the enabling of table compression in Oracle Database 11g is true?()
    A

     Compression can be enabled at the table, tablespace, or partition level for direct loads only.

    B

     Compression can be enabled only at the table level for both direct loads and conventional DML.

    C

     Compression can be enabled at the table, tablespace, or partition level for conventional DML only.

    D

     Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.


    正确答案: D
    解析: 暂无解析

  • 第11题:

    多选题
    Which two statements are true about setting the per-thread buffers higher than required?()
    A

    More memory per thread is beneficial in all scenarios

    B

    It causes increased overhead due to initial memory allocation

    C

    It can affect system stability during peak load times, due to swapping

    D

    It requires increasing the thread_cache_size variable


    正确答案: B,D
    解析: 暂无解析

  • 第12题:

    多选题
    Which statements are true regarding table compression?()
    A

    It saves disk space and reduces memory usage.

    B

    It saves disk space but has no effect on memory usage.

    C

    It incurs extra CPU overhead during DML as well as direct loading operations.

    D

    It incurs extra CPU overhead during DML but not direct loading operations.

    E

    It requires uncompress operation during I/O.


    正确答案: E,B
    解析: 暂无解析

  • 第13题:

    Given the following code fragment:     public void create() {     Vector myVect;     myVect = new Vector();      }  Which of the following statements are true?() 

    • A、 The declaration on line 2 does not allocate memory space for the variable myVect.
    • B、 The declaration on line 2 allocates memory space for a reference to a Vector object.
    • C、 The statement on line 2 creates an object of class Vector.
    • D、 The statement on line 3 creates an object of class Vector.
    • E、 The statement on line 3 allocates memory space for an object of class Vector.

    正确答案:A,D,E

  • 第14题:

    Which statement is true regarding the Junos OS?()

    • A、Each process runs in its own protected memory space ensuring that one process cannot directly interface with another
    • B、Process share memory space but separate ASICs so that one process cannot directly interfere with another
    • C、A central processor called the IP2 chip dynamically assings memory as process needs fluctuate
    • D、The memory management daemon (mmd) is responsible for allocating new memory for process as they request it

    正确答案:A

  • 第15题:

    Which two statements are true about setting the per-thread buffers higher than required?()

    • A、More memory per thread is beneficial in all scenarios
    • B、It causes increased overhead due to initial memory allocation
    • C、It can affect system stability during peak load times, due to swapping
    • D、It requires increasing the thread_cache_size variable

    正确答案:B,C

  • 第16题:

    Which statement about the enabling of table compression in Oracle Database 11g is true?()

    • A、Compression can be enabled at the table, tablespace, or partition level for direct loads only.
    • B、Compression can be enabled only at the table level for both direct loads and conventional DML.
    • C、Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
    • D、Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

    正确答案:D

  • 第17题:

    You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?()

    • A、You are backing up to tape and your tape device performs its own compression.
    • B、You are making image copies, and you have not enabled tablespace compression.
    • C、You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
    • D、You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
    • E、You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.

    正确答案:C,D,E

  • 第18题:

    多选题
    Which statements are true regarding table compression? ()(Choose all that apply.)
    A

    It saves disk space and reduces memory usage.

    B

    It saves disk space but has no effect on memory usage.

    C

    It incurs extra CPU overhead during DML as well as direct loading operations.

    D

    It incurs extra CPU overhead during DML but not direct loading operations.

    E

    It requires uncompress operation during I/O.


    正确答案: D,A
    解析: 暂无解析

  • 第19题:

    多选题
    You issue the command show process memory ∣ include BGP and notice that BGP is consuming alarge percentage of the router’s memory. Which of the following steps would result in lowering theamount of memory being consumed by BGP?(Choose all that apply.)()
    A

    Filter unneeded BGP routes

    B

    Run BGP on a different platform that already has more memory

    C

    Upgrade the router memory

    D

    Increase the BGP update timer

    E

    Compress the BGP table

    F

    Use a default route instead of maintaining a full BGP table


    正确答案: C,A
    解析: 暂无解析

  • 第20题:

    单选题
    Which system resources does WLM have the capability to control?()
    A

     CPU, Memory and Network I/O 

    B

     CPU, Memory and Disk I/O 

    C

     CPU and Memory 

    D

     CPU and Disk I/O


    正确答案: C
    解析: 暂无解析

  • 第21题:

    多选题
    You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?()
    A

    You are backing up to tape and your tape device performs its own compression.

    B

    You are making image copies, and you have not enabled tablespace compression.

    C

    You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.

    D

    You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.

    E

    You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.


    正确答案: C,A
    解析: 暂无解析

  • 第22题:

    多选题
    Given the following code fragment:     public void create() {     Vector myVect;     myVect = new Vector();      }  Which of the following statements are true?()
    A

    The declaration on line 2 does not allocate memory space for the variable myVect.

    B

    The declaration on line 2 allocates memory space for a reference to a Vector object.

    C

    The statement on line 2 creates an object of class Vector.

    D

    The statement on line 3 creates an object of class Vector.

    E

    The statement on line 3 allocates memory space for an object of class Vector.


    正确答案: C,D
    解析: SL-275中指出:要为一个新对象分配空间必须执行new Xxx()调用,new调用执行以下的操作: 
    1.为新对象分配空间并将其成员初始化为0或者null。 
    2.执行类体中的初始化。(例如在类中有一个成员声明int a=10;在第一步后a=0 ,执行到第二步后a=10)    
    3.执行构造函数。 
    4.变量被分配为一个到内存堆中的新对象的引用。

  • 第23题:

    多选题
    Which three statements are characteristic of the MEMORY storage engine?()
    A

    It can support transactions

    B

    Table contents are not saved if the server is restarted

    C

    It cannot contain text or BLOB columns

    D

    It can support foreign keys

    E

    Each table is represented on disk as an.frm file

    F

    Each table has a corresponding.MYI and .MYD file


    正确答案: C,F
    解析: 暂无解析

  • 第24题:

    单选题
    Which statement is true about the Manageability Monitor (MMON) background proces()
    A

    It transfers statistics from memory to disk at regular intervals.

    B

    It coordinates the rebalance activity for disk groups when ASM is used.

    C

    It communicates with the Automatic Storage Management (ASM) instance on behalf of the databaseinstance.

    D

    It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.


    正确答案: B
    解析: 暂无解析