单选题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题：

A new switch is installed into an existing LAN and a new VTP trunk is set up with an existing switch. Which VLANs will be allowed on this new trunk?（）

• A、All defined VLANs are allowed on the trunk by default.
• B、Each VLAN, or VLAN range, that is specified with the switchport mode command.
• C、Each VLAN, or VLAN range, that is specified with the vtp domain command.
• D、Each VLAN, or VLAN range, that is specified with the vlan database command.

第2题：

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

第3题：

第4题：

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.

第5题：

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

第6题：

You decided to change the location of the flash recovery area. You executed the following command： 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.

第7题：

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

第8题：

第9题：

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.

第10题：

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.