单项选择题
You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server 2008 instance. Look at the following query: SELECT s.*, i.* FROM SensitiveTbl AS s INNER JOIN InsensitiveTbl AS iON i. OrganizationName = s.OrganizationName You use the above query to join two tables on a column named OrganizationName. The following error is returned when you execute the query. "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between 'SQL_Latin1_General_CP1_CS_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation." The ON clause of the query has to be modified so that it can perform a case-sensitive joinsuccessfully. What should you do? （）
A.ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)
B.ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName)
C.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS
D.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS
相关考题
-
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasewhichisnamedSellingsintheinstance.TheSellingsdatabasecontainsatablenamedProductions.Thetableisusedtostoresinformationaboutalltypesofproducts.TheProductionstableisoftenqueriedbyusersonthebasisoftheRadioSizecolumn.TheRadioSizecolumncontainstheNULLvalueforallproductsotherthanRadios.Currentlynoindex existsontheRadionSizecolumn.AccordingtotherequirementofthecompanyCIO,youhavetooptimizethequeryperformanceandreducetheeffectonthediskspacetotheleast.Sowhatactionshouldyouperformtoachievethisgoal?（）
A.On the Products table, you should create a view.
B.On the RadioSize column, you should create a clustered index
C.On the RadioSize column, you should create a filtered index
D.On the RadioSize column, you should create a unique clustered index -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehasatable namedOrderthings.Accordingtothecompanyrequirement,youhavetoexportalldatafromtheOrderthingstabletoafile.Duringtheexport,youmustmakesurethatthedataexportprocessissavedforreuseandaMicrosoftOfficeOpenXMLdocumentformatisused.Whatshouldyoudo?（）
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
