1. [单选题]You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.
A. What should you do?
B. Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.
C. Create a trigger to delete any bids that have a closing data older than one year. Bind the trigger to the bids table for all INSERT, UPDATE, and DELETE events.
D. Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.
E. Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.
2. [单选题]Your network includes Windows 98 computers and Windows 2000 Server computers. You are adding a new computer to the network, and you plan to install Windows 2000 Server on the new computer. The computer has one 20-GB hard disk with no partitions defined.The Windows 2000 Server CD-ROM is unavailable. You want install Windows 2000 Server from source files that are located on a server on the network. You also want the entire hard disk of the new computer to be used for the system partition.
A. What should you do?
B. On another Windows 2000 computer, use Makebt32.exe to create installation startup disks. Start the new computer by using the first disk.
C. On another Windows 2000 computer, format a floppy disk. Copy NTLDR, Boot.ini, Ntdetect.com, Ntbootdd.sys to this disk. Start the new computer by using the disk.
D. Start the new computer by using a Windows 98 network boot disk. Connect to the network server. Run Dsclient.exe. Create and format a 20-GB FAT32 partition.
E. Start the new computer by using a Windows 98 network boot disk. Create and format a single FAT32 partition. Connect to the network server. Run Winnt.exe.
F. Start the computer by using a Windows 98 network boot disk. Create and format a single FAT32 partition. Start the new computer by using a Windows 2000 Emergency Repair Disk.
3. [单选题]You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.
A. What should you do?
B. Enable the torn page detection database option for each database.
C. Disable write caching on all disk controllers.
D. Ensure that write caching disk controllers have battery backups.
E. Create a database maintenance plan to check database integrity and make repairs each night.
4. [单选题]You copy the contents of the Windows 2000 Professional CD to a shared network folder named \\Server1\Win2000p. You use the shared folder to perform. over-the-network installations of Windows 2000 Professional on new computers purchased by your company.You receive a Windows 2000 Service Pack CD. You apply the Service Pack to Server1 and to the \\Server1\Win2000p folder.
A. You discover that the Service Pack contains several files that are incompatible with the new computers.
B. You want to make sure that the Service Pack files are not installed on any new computers until the problem has been corrected. What can you do?
C. Use Update.exe from the Service Pack CD on server1.
D. Select the Uninstall option.
E. Copy the contents of the Windows 2000 Professional CD to \\Server1\Win2000p again, allowing the operating system to overwrite newer files while copying.
F. Run\\Server1\Win2000p\WinNT32.exe/uon the new computer.
G. RunUpdate.exe/s:\\Server1\Win2000p/ufrom the Service Pack CD on Server1.
5. [多选题]You are the network administrator for Ezonexam. The network consists of a single Active Directory domain Ezonexam.com. All network servers run Windows Server 2000.Your network includes a shared folder named EzonexamDocs. This folder must not be visible in a browse list.
A. However, users report that they can see EzonexamDocs when they browse for shared folders.
B. How should you solve this problem?
C. Modify the share permissions to remove the All - Read permission on EzonexamDocs from the Users group.
D. Modify the NTFS permissions to remove the Allow - Read permissions on EzonexamDocs from the Users group.
E. Change the share name to EzonexamDocs .
F. Change the share name to EzonexamDocs $.
