多选题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？（）AIt readily responds to dynamic changes for concurr

第1题：

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

第2题：

Which three tasks can be performed using a duplicate database? （）(Choose three.)

• 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

第3题：

You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

• A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
• B、 executing a long query that involves a sort operation and the statement runs out of temporary space
• C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
• D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

第4题：

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.

第5题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The database on the Microsoft SQL Server 2005 database has two tables that are displayed by using two SqlConnection objects in two different GridView controls. You want the tables to be displayed at the same time with the use a single SqlConnection object.   What should you do？（）

• A、 Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.
• B、 Enable Multiple Active Result Sets （MARS） in the connection string of the application. 
• C、 Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.
• D、 Run the two SqlDataReader objects by using a single SqlCommand object.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

• A、run a procedure to check the tablespace space usage
• B、define the warning threshold for the tablespace at 75% in Database Control
• C、create a trigger to be executed when tablespace space usage reaches 75%
• D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
• E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

第14题：

Which two are characteristics of user-managed backup and recovery operations？（）

• A、Recovery is initiated using SQL*Plus.
• B、Database files are backed up using SQL commands.
• C、Database files are backed up with Recovery Manager.
• D、Database files are restored using Recovery Manager.
• E、Database files are backed up using operating system commands.

第15题：

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.

第16题：

You are the network administrator for  You administare a Windows Server 2003 computer named TestKing12. TestKing12 has a single disk. The disk is configured so that it has four primary partitions, which are formatted as FAT32. The disk also has unallocated space available. You need to use the unallocated disk space to store user data. What should you use?（）

• A、Convert all existing partitions to NTFS.
• B、Using Diskpart.exe, run the create command.
• C、Convert the disk to a dynamic disk, and create a new volume.
• D、Using Diskpart.exe, run the extend command.

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：