多选题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 concurrent access.BIt improves performance and space utilization in a multiple-instance environment.CIt requires fewer space related options then freelist managed structures.DIt improves performance for SYSTEM tablespaces where a high degree of concurrency is required.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
Which of the following database objects is considered executable using SQL?() A.ViewB.TableC.RoutineD.Package
Which three are benefits of A virtualized data center solution over A typical implementation?（）A、simplified cablingB、more efficient routingC、fewer applications per serverD、more efficient power consumptionE、more control over each serverF、less rack space
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 tunnelB、supports multi-protocol （non-IP） traffic over the tunnelC、reduces IPsec headers overhead since tunnel mode is usedD、simplifies the ACL used in the crypto mapE、uses Virtual Tunnel Interface （VTI） to simplify the IPsec VPN configuration
Which of the following database objects is considered executable using SQL?（）A、ViewB、TableC、RoutineD、Package
Which two changes and their effect on the system can be tested by using the Database Replay feature？（）A、 multiplexing of the control fileB、 adding the redo log member to the databaseC、 database and operating system upgradesD、 changing the database storage to ASM-managed storage
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 usageB、define the warning threshold for the tablespace at 75% in Database ControlC、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 intervalsE、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
Which three tasks can be performed using a duplicate database? （）(Choose three.)A、Testing the backup and recovery proceduresB、Testing the upgrade of an Oracle database to a new releaseC、Testing the effect of an application changes on database performanceD、Continuously updating archive log files from the target database to support failover
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.
You issued the following statement in your SQL*Plus session： SQLALTER 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 tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
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.
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.
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.
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.
单选题An application running on a production cluster failed over to the backup node， however， the DLPARintegration scripts failed. On inspection， it was discovered that the scripts failed as a result of /var being 100% full. The administratoradded more space to /var and ran the following command： Which of the following is the correct next action？（）A Refresh the RMC daemon using rmcctrlB Refresh the RSCT subsystem using SRCC Recover from script failure using clruncmdD Reconfigure the RSCT subsystem using recfgct
多选题Which two changes and their effect on the system can be tested by using the Database Replay feature？（）Amultiplexing of the control fileBadding the redo log member to the databaseCdatabase and operating system upgradesDchanging the database storage to ASM-managed storage
多选题Which three are benefits of A virtualized data center solution over A typical implementation?（）Asimplified cablingBmore efficient routingCfewer applications per serverDmore efficient power consumptionEmore control over each serverFless rack space
多选题Which three functions are performed by the SQL Tuning Advisor?（）ABuilding and implementing SQL profilesBRecommending the optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B-tree indexesERecommending the restructuring of SQL queries that are using bad plans
多选题Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)ABuilding the SQL profileBRecommending optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B-tree indexesERecommending restructuring SQL queries that are using bad plans
多选题Which three tasks can be performed using a duplicate database? （）(Choose three.)ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
多选题Which three protocols should be explicitly managed by using a CoPP policy on an Internet border router？（）ASMTPBICMPCBGPDSSHERTPFBitTorrentGVTP
多选题Which three protocols should be explicitly managed by using Control Plane Policing on an Internet border router？（）ALDAPBICMPCRTPDBGPESSHFRDP
多选题Which three functions are performed by the SQL Tuning Advisor？（）ABuilding the SQL profileBRecommending optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap， function-based， and B-tree indexesERecommending restructuring SQL queries that are using bad plans
多选题Which three features are benefits of using GRE tunnels in conjunction with IPsec for building site-to-site VPNs？（）Aallows dynamic routing over the tunnelBsupports multi-protocol （non-IP） traffic over the tunnelCreduces IPsec headers overhead since tunnel mode is usedDsimplifies the ACL used in the crypto mapEuses Virtual Tunnel Interface （VTI） to simplify the IPsec VPN configuration
单选题You issued the following statement in your SQL*Plus session： SQLALTER 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 tablespaceB executing a long query that involves a sort operation and the statement runs out of temporary spaceC loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
多选题Which three tasks can be performed using a duplicate database？（）ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
多选题Which three changes should be made to adapt this class to be used safely by multiple threads？（）Adeclare reset（） using the synchronized keywordBdeclare getName（） using the synchronized keywordCdeclare getCount（） using the synchronized keywordDdeclare the constructor using the synchronized keywordEdeclare increment（） using the synchronized keyword
多选题For which two situations would you use functionality provided by the Resource Manager？（）Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDassigning priorities to jobs to manage access to system resourcesEcreating alerts to perform notification when tablespaces are low on available space resources