多选题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 operations.DIt incurs extra CPU overhead during DML but not direct loading operations.EIt requires uncompress operation during I/O.
多选题
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.) 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 two statements are true about setting the per－thread buffers higher than required?() A.More memory per thread is beneficial in all scenariosB.It causes increased overhead due to initial memory allocationC.It can affect system stability during peak load times, due to swappingD.It requires increasing the thread_cache_size variable
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 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 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
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.
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.
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 anotherB、Process share memory space but separate ASICs so that one process cannot directly interfere with anotherC、A central processor called the IP2 chip dynamically assings memory as process needs fluctuateD、The memory management daemon (mmd) is responsible for allocating new memory for process as they request it
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.
Which two statements are true about setting the per-thread buffers higher than required?（）A、More memory per thread is beneficial in all scenariosB、It causes increased overhead due to initial memory allocationC、It can affect system stability during peak load times, due to swappingD、It requires increasing the thread_cache_size variable
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.
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.
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
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.
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.
多选题Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）AAs ASM instance mounts an ASM control fileBAn ASM instance uses the ASMB process for rebalancing of disks within a disk groupCAutomatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyDAn RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
多选题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.）（）AFilter unneeded BGP routesBRun BGP on a different platform that already has more memoryCUpgrade the router memoryDIncrease the BGP update timerECompress the BGP tableFUse a default route instead of maintaining a full BGP table
单选题Which statements about the MEMORY_TARGET initialization parameter are true?（） (Choose all that apply.)AMEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroBMEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setCMEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.DMEMORY_TARGET is static and cannot be modified without shutting down the instance
单选题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
多选题Which of the following statements about declaration are true？（）ADeclaration of primitive types such as boolean， byte and so on does not allocate memory space for the variable.BDeclaration of primitive types such as boolean， byte and so on allocates memory space for the variable.CDeclaration of nonprimitive types such as String， Vector and so on does not allocate memory space for the object.DDeclaration of nonprimitive types such as String， Vector ans so on allocates memory space for the object.
多选题You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）AYou are backing up to tape and your tape device performs its own compression.BYou are making image copies, and you have not enabled tablespace compression.CYou are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.DYou are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.EYou are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
单选题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.
多选题Given the following code fragment： public void create（） { Vector myVect； myVect = new Vector（）； } Which of the following statements are true？（）AThe declaration on line 2 does not allocate memory space for the variable myVect.BThe declaration on line 2 allocates memory space for a reference to a Vector object.CThe statement on line 2 creates an object of class Vector.DThe statement on line 3 creates an object of class Vector.EThe statement on line 3 allocates memory space for an object of class Vector.
多选题Which two statements are true about setting the per-thread buffers higher than required?（）AMore memory per thread is beneficial in all scenariosBIt causes increased overhead due to initial memory allocationCIt can affect system stability during peak load times, due to swappingDIt requires increasing the thread_cache_size variable
多选题Which three statements are characteristic of the MEMORY storage engine?（）AIt can support transactionsBTable contents are not saved if the server is restartedCIt cannot contain text or BLOB columnsDIt can support foreign keysEEach table is represented on disk as an.frm fileFEach 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 CPU overhead during DML but not direct loading operations.EIt requires uncompress operation during I/O.
单选题Which statement is true about the Manageability Monitor （MMON） background proces（）AIt transfers statistics from memory to disk at regular intervals.BIt coordinates the rebalance activity for disk groups when ASM is used.CIt communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.DIt performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.