You want the package to execute automatically each evening at 8:00 P.M. What should you do?
A. Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B. Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D. Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
查看答案
You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.
You need to import data into the database without adversely affecting database performance. The data will require an additional 2GB of storage space.
What should you do?
Add another data file on drive E, and then add the file to the PRIMARY filegroup.
B. Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option.
C. Rebuild all clustered indexes so that they have a fill factor of 100.
D. Compress drive D.
如试题图1-2所示单杆活塞缸,工作台右移动时速度为V1,推力为F1;工作台左移时速度为V2,推力为F2。下列四种情况中正确的是()。
A. V2<V1, F2<F1
B. V2<.sub>>V1,F2>F1
C. V2>V1, F2<F1
D. V2<V1,F2>F1