[单选题]You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use the
正确答案 ：E
Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.
解析：解析：Explanation:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.WecanthusrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.IncorrectAnswers:A:TherebuildmutilityrebuildsthemasterdatabaseandcanbeusedtochangethecollationsettingsofaninstanceofSQLServer2000,ortofixacorruptedmasterdatabase.Rebuildingthemasterdatabaseinvolvesremovesalldatabaseobjectsanddata,re-createthedatabaseobjectsandreloadthedata,orreattachthedataandlogfilesusingsp_attach_dbwhentherebuildiscomplete.C:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.ItisthusnotnecessarytoinstallanewinstanceofSQLServer2000inordertorestorethedata.WecaninsteadrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.D:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.ItisthusnotnecessarytoinstallanewinstanceofSQLServer2000onanewcomputerinordertorestorethedata.WecaninsteadrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.
[单选题]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.
[单选题]You are configuring 5 computers to use both Windows NT workstation 4.0 and Windows 2000 Professional. Each computer has an 8GB hard disk. You configure that hard disk on each computer to have two 4GB partitions. Windows NT workstation is installed on drive C. Windows 2000 Professional is installed on drive D. In Windows 2000 Professional you configure a disk quota on drive D to prevent users from saving work files on the disk. You restart the computer and load Windows NT workstation.You notice that users can still save files to drive D.
正确答案 ：D
Use Windows NT workstation to configure NTFS permission on drive D to deny the users write permission.
解析：解析：Explanation: To prevent both Windows NT 4.0 Workstation and Windows 2000 Professional users from writing to the D drive, NTFS permissions must be used. For example, it could be used to deny users write permission.
[多选题]You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.
正确答案 ：DF
Perform. a combination of full database, differential, and transaction log backups.
Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.
解析：解析：Explanation:
[单选题]You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:BULK INSERT finance.dbo.customers
正确答案 ：H
Remove the TABLOCK option from the BULK INSERT statement.
解析：解析：Explanation: The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.
[单选题]You want to upgrade 400 computers from Windows 95 to Windows 2000 Professional. Most of the computers in your company use the same hardware. However, several different peripheral devices are used throughout the company.You want to verify that the hardware in use is compatible with Windows 2000 Professional. You want to accomplish this with least amount of administrative effort.
正确答案 ：E
Use Setup Manager to create a Setup.inf file. Add the entryReportOnly=Yes to the [Win9xUpg] section of the answer file. RunWinnt32.exe /Unattended:Setup.infon all of the different computer configurations.
解析：解析：Explanation: Winnt32.exe /unattended:setup.inf will start an unattended installation using the answer file setup.inf. When ReportOnly=Yes is added in the [Win9xUpg] section of the answer file, the installation only generates an upgrade report and then exits without making any changes to the current Windows 95 or Windows 98 installation. The upgrade report contains a list of hardware and software incompatibilities and is saved to the root of the system drive if the SaveReportTo key is not specified.
[多选题]You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)
正确答案 ：ABE
Apply a bulk update lock to the table.
Use separate client connections to load the files into the table simultaneously.
Specify the Bulk-Logged Recovery model for the database.
解析：解析：Explanation:
[单选题]On a Windows 2000 Professional computer, you run a shipping application that prints packing labels to a laser printer for every outgoing shipment, 24 hours per day. During peak hours, your company ships more than 1,000 packages per hour.You have just purchased a second identical laser printer to aid in printing. You want to configure the printers so that the jobs are load balanced. You connect the second laser printer to the computer.
正确答案 ：C
Enable printer pooling.
解析：解析：Explanation: To load balance print jobs on two printers you must create a printer pool. The printer pool will then automatically distribute the print jobs to the first available print device and the print jobs will be load balanced.
[单选题]You are the administrator of a Windows 2000 Active Directory network. The network consists of a single domain. The domain includes 20 Windows NT Workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers.You create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator. This default user policy denies access to Network Neighborhood. You then install Terminal Services on one of the servers and Terminal Services Client on the 20 Windows NT Workstation client computers.
正确答案 ：E
Create a Windows 2000 Group Policy that denies user access to My Network Places.
解析：解析：Explanation: Windows NT 4.0 system polices affect computers running Windows NT 4.0. The Windows NT computers in this scenario are being used as Terminals for the Windows 2000 Server computer that is running Terminal Services. In effect the Windows NT clients are running locally on the Windows 2000 Server. The restriction must be applied on the Windows 2000 Server. This can be done by using a group policy.
[单选题]You are preparing to install Windows 2000 Server on a new computer. The computer is connected to a network that includes Windows 98 computers and Windows 2000 Server computers.You want to install Windows 2000 Server from source files that are located on a server on the network.
正确答案 ：C
Start the new computer by using Windows 98 network boot disk. Connect to the network server. Run Winnt.exe.
解析：解析：Explanation: To install Windows 2000 Server on a computer from source files that are located in a centralized network location we would have to create a network boot disk that includes DOS drivers for the network adapter. We would have to start the computer using this boot disk and connect to the network share where the source files are located. Finally we would start installation process by using winnt.exe. We must use winnt.exe and not winnt32.exe as the boot disks operate in DOS mode, which works with 16-bit applications. We would thus not be able to use 32-bit applications like winnt32.exe.
查看原题
