多选题Which statements are true regarding table compression？（）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 operations.DIt incurs extra 

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

相似考题

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

2.A technician notices that there is a second partition on the primary hard drive. This partitionis notassigned a drive letter and is not accessible from Windows. Which of the following is the MOST likely explanation for this extra partition?（）A、Space reserved by the drive manufacturer for firmware.B、Space set aside by Windows for use by the virtual memory swap file.C、A potentially dangerous virus has been downloaded onto the system.D、A recovery partition put there by the manufacturer.

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

4.Which three statements are characteristic of the MEMORY storage engine?()A.It can support transactionsB.Table contents are not saved if the server is restartedC.It cannot contain text or BLOB columnsD.It can support foreign keysE.Each table is represented on disk as an.frm fileF.Each table has a corresponding.MYI and .MYD file

更多“多选题Which statements are true regarding table compression？（）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 operations.DIt incurs extra ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

    正确答案:C,D

  • 第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题：

    Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choosetwo.)

    • 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

    正确答案:C,D

  • 第7题：

    多选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第10题：

    多选题
    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．变量被分配为一个到内存堆中的新对象的引用。

  • 第11题：

    多选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第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 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

  • 第15题：

    ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）

    • A、The data is decrypted during SORT and JOIN operations.
    • B、The data remains encrypted when it is read into memory.
    • C、The data remains encrypted when it is stored in the redo logs.
    • D、The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

    正确答案: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题：

    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

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    多选题
    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的正确性还有待官方的确定。

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    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
    解析： 暂无解析

  • 第24题：

    多选题
    A company is deploying a Microsoft Windows-based， mission-critical Data Warehousing application.  The customer has specified 4GB of RAM.  Which TWO of the following questions will best help the consultant determine the proper memory configuration？（）
    A

    Does the application require a large paging space？

    B

    What is the anticipated memory/disk cache hit ratio？

    C

    Does the application support Physical Address Extensions （PAE）？

    D

    Are there future plans to expand the amount of memory in the system？

    E

    Do the application availability requirements justify the use of Memory Mirroring technologies？


    正确答案： E,A
    解析： 暂无解析

相关内容