You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.
During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.
You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.
What should you do?
A．Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
B．Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.
C．Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.
D．Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
答案说明：本题目答案来自网络整理或转载，最终答案请以官网为准。
答 案：C
解析：Explanation:ThecollationofadatabasecanbespecifiedintheCOLLATEclauseoftheALTERDATABASEstatement.Thiswillchangethedefaultcollationofthedatabasethatwasspecifiedwhenthedatabasewascreated,ortoalterthecollationforadatabasewherethecollationwasnotspecifiedwhenthedatabasewascreatedandthusthedefaultcollationoftheserverwasused.IncorrectAnswers:A:ThecollationofadatabasecanbealteredusingtheCOLLATEclauseoftheALTERDATABASEstatement.ItisthereforenotnecessarytoreinstalltheinstanceofSQLServer2000ortorerunthesetupprogram.Furthermore,rerunningtheSQLServer2000setupprogramwoulddisrupttheperformanceoftheSQLServercomputer.B:TherebuildmutilityaltersthemasterdatabaseandcanbeusedtochangethecollationsettingsforaninstanceofSQLServer2000.However,itisonlytheFinancialdatabasethatneedstobealteredasitisfinancialapplicationistheonlyapplicationthatusestheSQL_Latin1_General_CP437_BINcollation.D:TheCOLLATEclausecanbespecifiedatdifferentlevels.Itcanbespecifiedforthedatabase,atable,acolumnoranexpression.Inthisscenariothecollationcanbealteredatthedatabaselevelasthiswillreduceadministrativeeffortwhennewtablesareaddedtothedatabase.