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 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 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 regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.) A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
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
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？
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 regarding an Automatic Storage Management (ASM) instance? （）A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
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.
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 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.
Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choosetwo.)A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
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.
单选题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.
多选题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 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
多选题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.
多选题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？（）ADoes the application require a large paging space？BWhat is the anticipated memory/disk cache hit ratio？CDoes the application support Physical Address Extensions （PAE）？DAre there future plans to expand the amount of memory in the system？EDo the application availability requirements justify the use of Memory Mirroring technologies？