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.)
Apply a bulk update lock to the table.
B. Use separate client connections to load the files into the table simultaneously.
Create a clustered index on the table.
D. Specify the Full Recovery model for the database.
E. Specify the Bulk-Logged Recovery model for the database.
查看答案
You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard disks on your server are configured as shown in the exhibit.
The operating system files are located on drive C. Your database will store a maximum of 6 GB of data and requires a maximum of 2 GB of disk space for the transaction log.
You want to optimize database performance. What should you do?
Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F
B. Add a 1-GB transaction log to drive C, a 1-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F
C. Add a 1-GB transaction log to drive E, a 1-GB transaction log to drive F, a 3-GB data file to drive E, and a 3-GB data file to drive F
D. Add a 2-GB transaction log to drive F, a 3-GB data file to drive D, and a 3-GB data file to drive E
企业能否向投资者分配利润,关键取决于该企业当年是盈利还是亏损。
A. 正确
B. 错误
在风险为本的持续经营监管框架中,以风险为本的现场检查是风险为本的监管最为核心的步骤。 ()
A. 正确
B. 错误
在资产组合管理中,如果各项资产的相关性为负,则风险分散效果差;如果相关性为正,则风险分散效果好。 ()
A. 正确
B. 错误