Oracle认证考试
Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）A、It readily responds to dynamic changes for concurren
题目
Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）
- A、It readily responds to dynamic changes for concurrent access.
- B、It improves performance and space utilization in a multiple-instance environment.
- C、It requires fewer space related options then freelist managed structures.
- D、It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.
参考答案和解析
相似问题和答案
第1题：
You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server has one hard disk that contains one volume.You need to receive a notification when the volume has less than 15 percent free disk space.What should you do? （）
A. Configure a Trace Log by using the File details system provider.
B. Configure a Trace Log by using the Disk input/output system provider.
C. Configure an Alert by using a counter from the Logical Disk performance object.
D. Configure an Alert by using a counter from the Physical Disk performance object.
第2题：
Which three features are benefits of using GRE tunnels in conjunction with IPsec for building site-to-site VPNs？（）
- A、allows dynamic routing over the tunnel
- B、supports multi-protocol （non-IP） traffic over the tunnel
- C、reduces IPsec headers overhead since tunnel mode is used
- D、simplifies the ACL used in the crypto map
- E、uses Virtual Tunnel Interface （VTI） to simplify the IPsec VPN configuration
正确答案:A,B,D
第3题：
A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover
第4题：
Which of the following database objects is considered executable using SQL?（）
- A、View
- B、Table
- C、Routine
- D、Package
正确答案:C
第5题：
A customer wants to implement the Software Inventory capabilities of IBM Director in their environment of 50 servers， 500 laptops and 150 desktops.Which of the following would represent a minimum valid configuration to support this solution？（）
- A、Windows 2000 server with 2GB free space， 2GB RAM and dual 1 GHz proc， using Access 2003
- B、Linux with 2.6 kernel and 2GB free space， 2GB RAM and dual 1 GHz proc， using MySQL
- C、Windows 2000 server with 2GB free space， 2GB RAM， dual 1 GHz proc with SMBIOS using MS Jet database
- D、Windows 2003 server with 2GB free space， 2GB RAM， dual 1 GHz proc with SMBIOS using MS SQL database
正确答案:D
第6题：
Which three are benefits of A virtualized data center solution over A typical implementation?（）
- A、simplified cabling
- B、more efficient routing
- C、fewer applications per server
- D、more efficient power consumption
- E、more control over each server
- F、less rack space
正确答案:A,D,F
第7题：
Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)
- A、Building the SQL profile
- B、Recommending optimization of materialized views
- C、Checking query objects for missing and stale statistics
- D、Recommending bitmap, function-based, and B-tree indexes
- E、Recommending restructuring SQL queries that are using bad plans
正确答案:A,C,E
第8题：
A.View
B.Table
C.Routine
D.Package
第9题：
An administrator is required to maintain space for 750GB of user data. Which of the following is the BEST option available to the administrator？（）
- A、Create a RAID 5 array using five 200GB disks.
- B、Create a JBOD using four 200GB disks.
- C、Create a RAID 1 array using six 200GB disks.
- D、Create a RAID 5 array using three 200GB disks.
正确答案:A
第10题：
Which two changes and their effect on the system can be tested by using the Database Replay feature？（）
- A、 multiplexing of the control file
- B、 adding the redo log member to the database
- C、 database and operating system upgrades
- D、 changing the database storage to ASM-managed storage
正确答案:C,D