【名词&注释】
正确答案:D。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. 更多微软认证的考试资料下载及答案解析请访问不凡考网计算机类考试考试频道。
[单选题]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.
查看答案&解析
点击获取本科目所有试题
举一反三：
[单选题]Ezonexam has 50 offices. The employees in these offices have limited knowledge of Windows 2000. Each office has a network of between five and 20 client computers. The office networks are connected to each other. The company is buying 50 identical computers to run Windows 2000 Server in these offices. The server must be installed to the company's standard configuration. You use Setup Manager to create a network shared distribution folder and a Unattend.txt file that specifies the company's standard configuration.You want to automate the installation process as much as possible, in the least possible amount of time.
A. What should you do?
B. Run Makebt32.exe to create four installation startup disks and add the Unattend.txt file to the first disk. Instruct an employee at each office to start the installation by using these disks.
C. Create a Microsoft MS-DOS network boot disk that makes a connection to the network shared distribution folder and runs the winnt command with the /s and /u switches. Instruct an employee at each office to start the installation by using this disk.
D. Create a floppy disk that contains only the Unattend.txt file. Instruct an employee at each office to start the installation by using the Windows 2000 Server compact disc, with the floppy disk inserted.
E. Create a Windows 2000 folder on a hard disk. Copy the Windows 2000 Server compact disc to the folder. Add the Unattend.txt file to the folder. Copy the folder to a writeable C Instruct an employee at each office to start the installation by suing this C
[单选题]You are the network administrator for Ezonexam.com. Your computer has a CD-ROM drive attached to a SCSI adapter. You plan to upgrade your computer from Windows NT Workstation 4.0 to Windows 2000 Professional. You determine that the SCSI adapter is not included on the current Hardware Compatibility List (HCL) and that the original SCSI drivers that you used for Windows NT are not compatible with Windows 2000 Professional.You want to upgrade your computer to Windows 2000 Professional.
A. What should you do?
B. Replace the SCSI adapter card with a Windows 2000 Professional compatible SCSI adapter. Start the installation from the Windows 2000 Professional CD-ROM. Add the new adapter card drivers when you are prompted.
C. Obtain Windows 2000 drivers from the SCSI adapter manufacturer. Copy the drivers to C:\Winnt folder. Start the installation from the Windows 2000 Professional CD-ROM.
D. Obtain Windows 2000 drivers from the SCSI adapter manufacturer. Start the installation by using the Windows 2000 Professional CD-ROM. Add the new adapter card drivers when you are prompted.
E. Modify Config.sys to use your existing SCSI adapter and existing CD-ROM drive. Using Windows NT 4.0, start the installation by running Winnt32.exe from the I386 folder on the Windows 2000 Professional CD-ROM.
[单选题]You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.
A. This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.
B. You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.
C. You want to create reports on the SQL Server computer by using the minimum amount of disk space.
D. What should you do?
E. Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.
F. Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.
G. Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.
H. Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.
[单选题]You need to create a web share on your Windows 2000 Professional computer named Admin01. You create a folder named reports. Then you configure web sharing on Reports. You name the share WebReports and allow Read permissions on the share.You test the web share by pointing to http://admin01/WebReports from another computer. You receive the following error message, 'You are not authorized to view this page.'
A. You need to be able to access the folder. What must you do?
B. Allow write permission on WebReports.
C. Allow directory browsing permissions on WebReports.
D. In the IIS console, enable anonymous access to WebReports.
E. In the IIS console, set the execute permissions option to script. and executables on WebReports.
[单选题]From your Windows 2000 Professional computer, you need to print from a 16-bit accounting application to a network printer named Printer02. Printer02 is attached to a print server named PrtSrv. The accounting application allows you to print only to a local LPT port.You currently have two printers attached to your local LPT1 and LPT2 ports. You need to be able to print to the network printer and to both local printers. You install the driver for the network printer on your computer.
A. What must you do next to enable printing on the network printer?
B. Create a new local printer port named PrtSrv\Printer02, and configure the printer to use the new port.
C. Create a new local printer port named PrtSrv\Printer02. In the properties for the new port, select the option to print directly to the printer. Configure the printer to use the new port.
D. Run thenet use Lpt3: \\PrtSrv\Printer02command.
E. Run thenet print\\PrtSrv\Printer02command.
[单选题]You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.What should you do?
A. Configure an ADM template and add the template to the GPO.
B. Configure an INF policy and add the policy to the GPO.
C. Configure a Microsoft Windows installer package and add the package to the GPO.
D. Configure RIS to include the registry entry.
[单选题]Ezonexam uses static TCP/IP addressing for its servers. You are installing Windows 2000 Server on a new computer named VE32. VE32 needs to join an existing Windows 2000 Active Directory domain named Ezonexam.com. While installing VE32 you are unable to join the existing domain. You use another Windows 2000 Server to attempt to create a computer account for the new server in the domain. When attempting to create the new computer account you receive the following message.Active Directory Service
A. The object VE32 could not be created.
B. The problem encountered was:
C. The directory service has exhausted the pool of relative identifiers.
D. You need to resolve the problem before continuing the installation.
E. What should you do?
F. Restart the domain's Global Catalog server.
G. Restart the domain's RID master server.
H. Restart the domain's PDC Emulator server.
I. Restart the domain's Infrastructure Master.
本文链接：https://www.zhukaozhuanjia.com/download/qxo49p.html
