单选题You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）AEnsure that the source database is Microsoft SQL Server.BEnsure that the destination database is Microsoft SQL Server.CEnsure that the column names in the source table match the column names in the destination table.DEnsure that the bulk copy program (bcp) utility is installed on the destination server.
单选题
You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）
A
Ensure that the source database is Microsoft SQL Server.
B
Ensure that the destination database is Microsoft SQL Server.
C
Ensure that the column names in the source table match the column names in the destination table.
D
Ensure that the bulk copy program (bcp) utility is installed on the destination server.
参考解析
解析：
暂无解析
相关考题：
One of the properties of light is () traveling in wave form. as it goes from one place to another. A.itB.it’sC.itsD.their
Importing and exporting is transferring goods from one country to another while _______ attention to the laws and requirements of bringing goods out or into that country. A、to payB、payingC、being paid
You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
The supply chain is the flow of () and services from one business to another. A、moneyB、intermediate goodsC、ECD、TPN
You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.
You have a single Active Directory domain. AlI domain controllers run Windows Server 2008 and are configured as DNS servers. The domain contains one Active Directory-integrated DNS zone. You need to ensure that outdated DNS records are automatically removed from the DNS zone. What should you do（）A、From the properties of the zone， enable scavenging.B、From the properties of the zone， disable dynamic updates.C、From the properties of the zone， modify the TTL of the SOA record.D、From the command prompt， run ipconfig /flushdns.
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（） A、 Issue the grant command from the SYS user （or equivalent） of the target database.B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、 Flash back all the tables in the data file， one by one.B、 Restore the data file to a new location and perform a media recovery.C、 Flash back the database， there is no need to restore the data file.D、 Restore the data file from the most recent backup and flash the database.
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member？（）A、import the database from the last exportB、restore all the members in the group from the last backupC、drop the lost member from the database， and then add a new member to the groupD、restore all the database files from the backup， and then perform a complete recovery E、restore all the database files from the backup， and then perform an incomplete recovery
You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）A、Ensure that the source database is Microsoft SQL Server.B、Ensure that the destination database is Microsoft SQL Server.C、Ensure that the column names in the source table match the column names in the destination table.D、Ensure that the bulk copy program (bcp) utility is installed on the destination server.
You develop an ASP.NET Web page that includes multiple WebPartZone controls， an EditorZone. Users report that they cannot customize the layout of the page by moving WebParts from one.You need to ensure that users can successfully move Web Parts from one zone to another. What should you do？（）A、Configure the Web site to enable session state.B、Configure the Web site to require authentication and to use personalization.C、Add a ProxyWebPartManager control to the page.D、Add a AppearanceEditorPart control to the page.
You work in a company which 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 DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（） A、You should implement Differential backup B、You should implement Database snapshotsC、You should implement Primary filegroup backup D、You should implement Transaction log backup
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options， which one is the most possible cause of the problem？（）A、The sp_executesql batches are not being recovered from the procedure cache.B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.C、One new stored procedure is created by a database administrator.D、Ad hoc batches are not being recovered from the procedure cache.
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）AMERGEBSELECT …CROSS JOINCINSERT ALL …SELECTDCREATE VIEW …CONSTRAINT
单选题Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem. Which point describes the Oracle Data Pump utility（）A1B2C3D4E1 and 3F1， 2， 3， and 4
单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）A Issue the grant command from the SYS user （or equivalent） of the target database.B Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E Issue the grant command from RMAN when connected to the target database.
多选题Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）AUse only the first address.BTry one address，selected at random.CTry each address，in order，until one succeeds.DTry each address，randomly，until one succeeds.
单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）AAfter two days, a backup will be marked obsoleteBAfter two days, a backup will be deleted from the mediaCIf the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.DIf the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
单选题A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A Flash back all the tables in the data file， one by one.B Restore the data file to a new location and perform a media recovery.C Flash back the database， there is no need to restore the data file.D Restore the data file from the most recent backup and flash the database.
单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）ASMON would automatically restore the lost file.BYou would need to restore the whole database from the last backup.CYou would need to restore the file from the last full database backup.DYou would need to use flashback technology to restore the lost redo log member.EYou would need to use Recovery Manager （RMAN） to restore the lost redo log member.FYou would need to restore the missing log file by copying one of the remaining files from the same group.
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）AREBUILDBCASCADECTRUNCATEDROW MOVEMENTESHRINK SPACE COMPACTFSHRINK SPACE CASCADE
单选题Note the following points describing various utilities in Oracle Database 11g： 1：It enables the high-speed transfer of data from one database to another. 2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3：It enables the loading of data from an external file into an Oracle database. 4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）A1B2C3D4E1，2，and 4F1，2，3，and 4
单选题In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A import the database from the last exportB restore all the members in the group from the last backupC drop the lost member from the database and then add a new member to the groupD restore all the database files from the backup and then perform a complete recoveryE restore all the database files from the backup and then perform an incomplete recovery
单选题What is a feature of the Integration Framework?（）AAllow bulk importing of XML or flat files. BAllow bulk importing from Excel spreadsheets.CAllow bulk importing from external/legacy system.DAllow bulk importing from one database platform to another.