单选题If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）A All existing databases in the instance are expanded to the new database partition but data cannot be stored on the new

第1题：

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）

• A、a tablespace is taken offline
• B、the database instance is restarted
• C、a new data file is added to an existing tablespace
• D、a successful backup is recorded in the RMAN repository
• E、the RMAN connection is disconnected from the target database

第2题：

You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）

• A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.
• B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’
• C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）
• D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

第3题：

Which statement is true about the database and database-user used during installation of IMS Server？（）

• A、A preexisting database user may be used but a new database has to be created during installation.
• B、A preexisting database may be used but a new database user has to be created during installation.
• C、A preexisting database and user may be used or a new database and user are created during installation.
• D、A preexisting database and user cannot be used； a new database and user are created during  installation.

第4题：

You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）

• A、 The location can be changed only if the flash recovery area is empty.
• B、 After executing the command， all new flash recovery area files will be created in the new location.
• C、 The command will generate an error because you cannot change the flash recovery area while the database is open.
• D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

第5题：

You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）  

• A、 ASMB
• B、 ARBn
• C、 RBAL in the ASM instance
• D、 RBAL in the database instance

第6题：

ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） 

• A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 
• B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 
• C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 
• D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

• A、 mount the new disk group in the ASM instance
• B、 restart the ASM instance and the production database instance
• C、 register the new disk groups in the production database instance
• D、 restart the ASM instance without restarting the production database instance
• E、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

第14题：

You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）

• A、Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.
• B、Ensure that the stored procedure and the tables are owned by the same database user.
• C、Ensure that the stored procedure and the tables use the same database schema.
• D、Configure the multiuser database option on both databases.
• E、Configure the cross-database ownership chaining option on both databases.

第15题：

If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）

• A、All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.  
• B、Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.  
• C、Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.  
• D、A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.

第16题：

Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

• A、mount the new disk group in the ASM instance
• B、restart the ASM instance and the production database instance
• C、register the new disk groups in the production database instance
• D、restart the ASM instance without restarting the production database instance
• E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

第17题：

You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）

• A、2，1，4，3，5，6
• B、1，4，3，2，6，5
• C、1，4，2，6，3，5
• D、3，2，1，4，5，6

第18题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? （）

• A、A new partition function should be created 
• B、You should change the existing partition scheme 
• C、You should use a Merge clause to change the existing partition function 
• D、You should use a Split clause to change the existing partition function 

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：