单项选择题

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. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）

A.You should run the bulk copy program utility along with an output file and no format file
B.You should run the SQLCmd utility and save the output to a file
C.You should run the SQL Import and Export Data Wizard and save the output to a file.
D.You should run the bulk copy program utility along with a format file and an output file.

<上一题目录下一题>

热门试题

单项选择题

YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.NowyougetareportfromuserssayingthatDB1meetsdeadlockproblems.Asthetechnicalsupport,youhavetocapturethedeadlockinformationtotheSQLServererrorlog.Whatshouldyoudo?（）

A.For the AdventureWorks database, enable Server Auditing
B.First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance
C.You should configure the data collector and make it capture the deadlock graphs
D.You should configure a SQL Profiler trace, and make it capture the deadlock graphs

单项选择题

YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehasatablenamedOrderthings.TheOrderthingstableispartitionedontheOrderIdcolumn.Thefirstpartitioncontainsintegervaluesgreaterthan100,000,whilethesecondpartitioncontainsintegervaluesbetween1and100,000.Youhavetoaddanewpartition.Thenewpartitionshouldcontainintegervaluesgreaterthan200,000.Whatshouldyoudo?（）

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