单选题If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）AAll 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. BDatabase partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition. CAny single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance. DA database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use theSQL_Latin1_General_CP1_CI_AS collation.You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.What should you do?A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
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.
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.
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.
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 offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database
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 instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
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
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.
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.
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.
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.
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 instanceB、restart the ASM instance and the production database instanceC、register the new disk groups in the production database instanceD、restart the ASM instance without restarting the production database instanceE、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
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、 ASMBB、 ARBnC、 RBAL in the ASM instanceD、 RBAL in the database instance
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，6B、1，4，3，2，6，5C、1，4，2，6，3，5D、3，2，1，4，5，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.
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
单选题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 instanceB restart the ASM instance and the production database instanceC register the new disk groups in the production database instanceD restart the ASM instance without restarting the production database instanceE include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
单选题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? （）AYou should install SQL Server 2008 as the default instance, and configure the new application to use the default instance BYou should upgrade the SQL Server 2005 application to use SQL Server 2008 CYou should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance DYou should install SQL Server 2008 as a named instance, and make the new application use the new instance.
单选题You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）AThe location can be changed only if the flash recovery area is empty.BAfter executing the command， all new flash recovery area files will be created in the new location.CThe command will generate an error because you cannot change the flash recovery area while the database is open.DAll 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.
多选题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？ （）Aa tablespace is taken offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database
单选题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? （）AA new partition function should be created BYou should change the existing partition scheme CYou should use a Merge clause to change the existing partition function DYou should use a Split clause to change the existing partition function
单选题Which statement is true about the database and database-user used during installation of IMS Server？（）AA preexisting database user may be used but a new database has to be created during installation.BA preexisting database may be used but a new database user has to be created during installation.CA preexisting database and user may be used or a new database and user are created during installation.DA preexisting database and user cannot be used； a new database and user are created during installation.
单选题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？（）ACreate a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.BCreate a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’CCreate a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）DCreate services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport
单选题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？（）Amount the new disk group in the ASM instanceBrestart the ASM instance and the production database instanceCregister the new disk groups in the production database instanceDrestart the ASM instance without restarting the production database instanceEinclude the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
单选题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. （）A2，1，4，3，5，6B1，4，3，2，6，5C1，4，2，6，3，5D3，2，1，4，5，6
单选题If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）AAll 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. BDatabase partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition. CAny single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance. DA database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
单选题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.
单选题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 ASMBB ARBnC RBAL in the ASM instanceD RBAL in the database instance