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

题目
单选题
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.

相似考题

1.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

2.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.

3.The supply chain is the flow of () and services from one business to another.A、moneyB、intermediate goodsC、ECD、TPN

4.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 transferring records from one database to another. Y”相关问题

  • 第1题：

    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.


    正确答案：A
    解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.

  • 第2题：

    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.

    正确答案:D

  • 第3题：

    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.

    正确答案:C

  • 第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.

    正确答案:D

  • 第5题：

    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 export
    • B、restore all the members in the group from the last backup
    • C、drop the lost member from the database， and then add a new member to the group
    • D、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

    正确答案:C

  • 第6题：

    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.

    正确答案:B

  • 第7题：

    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.

    正确答案:B

  • 第8题：

    单选题
    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（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1 and 3

    F

    1， 2， 3， and 4


    正确答案： B
    解析： 暂无解析

  • 第9题：

    多选题
    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？（）
    A

    Use only the first address.

    B

    Try one address，selected at random.

    C

    Try each address，in order，until one succeeds.

    D

    Try each address，randomly，until one succeeds.


    正确答案： C,A
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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？（）
    A

    REBUILD

    B

    CASCADE

    C

    TRUNCATE

    D

    ROW MOVEMENT

    E

    SHRINK SPACE COMPACT

    F

    SHRINK SPACE CASCADE


    正确答案： E
    解析： 暂无解析

  • 第12题：

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

    B

     restore all the members in the group from the last backup

    C

     drop the lost member from the database and then add a new member to the group

    D

     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


    正确答案： E
    解析： 暂无解析

  • 第13题：

    Let’s have a run through.This sentence means let’s run from one side to another.


    正确答案:错误

  • 第14题：

    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.

    正确答案:F

  • 第15题：

    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.

    正确答案:A

  • 第16题：

    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.

    正确答案:B

  • 第17题：

    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.

    正确答案:B

  • 第18题：

    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 snapshots
    • C、You should implement Primary filegroup backup 
    • D、You should implement Transaction log backup

    正确答案:B

  • 第19题：

    单选题
    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？（）
    A

    MERGE

    B

    SELECT …CROSS JOIN

    C

    INSERT ALL …SELECT

    D

    CREATE VIEW …CONSTRAINT


    正确答案： A
    解析： 暂无解析

  • 第20题：

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


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）
    A

    After two days, a backup will be marked obsolete

    B

    After two days, a backup will be deleted from the media

    C

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.

    D

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.


    正确答案： C
    解析： 暂无解析

  • 第22题：

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


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1，2，and 4

    F

    1，2，3，and 4


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    What is a feature of the Integration Framework?（）
    A

    Allow bulk importing of XML or flat files. 

    B

    Allow bulk importing from Excel spreadsheets.

    C

    Allow bulk importing from external/legacy system.

    D

    Allow bulk importing from one database platform to another.


    正确答案： D
    解析： 暂无解析

相关内容