题目内容

You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.
You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do？

A. Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executed
B. Use the sp_who stored procedure to discover who is logged in as spid 52
C. Use SQL Profiler to capture the activity of the user who is logged in as spid 52
D. Use System Monitor to log the locks that are granted in the database

查看答案

搜索结果不匹配？点我反馈

更多问题

作为无形资产人账的商誉，既可以白创，也可以外购。

A. 正确
B. 错误

查看答案

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. 错误

查看答案