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

正确答案 ：E

Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.

解析：解析：Explanation:ThecollationofadatabasecanbespecifiedintheCOLLATEclauseoftheALTERDATABASEstatement.Thiswillchangethedefaultcollationofthedatabasethatwasspecifiedwhenthedatabasewascreated,ortoalterthecollationforadatabasewherethecollationwasnotspecifiedwhenthedatabasewascreatedandthusthedefaultcollationoftheserverwasused.IncorrectAnswers:A:ThecollationofadatabasecanbealteredusingtheCOLLATEclauseoftheALTERDATABASEstatement.ItisthereforenotnecessarytoreinstalltheinstanceofSQLServer2000ortorerunthesetupprogram.Furthermore,rerunningtheSQLServer2000setupprogramwoulddisrupttheperformanceoftheSQLServercomputer.B:TherebuildmutilityaltersthemasterdatabaseandcanbeusedtochangethecollationsettingsforaninstanceofSQLServer2000.However,itisonlytheFinancialdatabasethatneedstobealteredasitisfinancialapplicationistheonlyapplicationthatusestheSQL_Latin1_General_CP437_BINcollation.D:TheCOLLATEclausecanbespecifiedatdifferentlevels.Itcanbespecifiedforthedatabase,atable,acolumnoranexpression.Inthisscenariothecollationcanbealteredatthedatabaselevelasthiswillreduceadministrativeeffortwhennewtablesareaddedtothedatabase.

[单选题]Your company network includes 6,000 Windows 2000 Professional client computers and 35 Windows 2000 Server computers in a single domain.Your company has a print device that is used to print payroll checks. The print device is physically attached to the parallel port of one of the client computers. This print device's tray is loaded with checks at all times. You have shared this printer on the network as ChkPrinter and retained the default permissions.

正确答案 ：F

Configure ChkPrinter to allow the HRserv domain account print permissions for ChkPrinter. Remove print permissions for the Everyone group.

解析：解析：Explanation:TheprintapplicationisrunasaserviceaccountintheHRservdomain.Bygrantingthisaccountprintpermissions,andremovingprintpermissionsfortheEveryonegroup,onlythepayrollapplicationwillbeabletousetheprinter.Incorrectanswers:A:BychangingthesharenametoChkPrinter$thenamewouldbehidden,butitcouldstillbeusedbyeveryone,sincetheEveryonegroupgetsprintpermissionsbydefault.B:Restrictingtheavailabletimewillnotpreventusersfromusingtheprinterwhenitisavailable.Theapplicationwouldnotbeabletousetheprinterduringthetimesitisconfiguredtobeunavailable.D:IftheEveryonegroupisdeniedprintpermissionontheprinter,noteventheapplicationwouldbeabletousetheprinter.

[单选题]You want to install Windows 2000 Professional on 45 new computers on your company's network. You first install Windows 2000 Professional on one of the new computers.You log on to the computer by using the local Administrator account. You install Microsoft Office 97, a virus scanner, and other company-standard applications. You then create a RIS image of the computer you configured.

正确答案 ：E

Copy the local Administrator account profile to the Default Users profile

解析：解析：Explanation: By copying the local Administrator account profile to the default users profile, all users will get access to the shortcuts, which were made when the local administrator installed the applications.

查看原题