题目内容

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The Inventory database has a table named StorageLocations that stores the location of parts contained in your company's warehouses. The StorageLocations table is configured as shown in the exhibit.
The LocationDescription field is usually described with a name 10 to 25 characters in length. The locations never store more than 100,000 units of any given part.
You want to modify the table's schema to save space. You cannot lose any existing data. You want to do this by using the minimum amount of administrative time and server resources.
Which Transact-SQL statement should you execute？

ALTER TABLE [dbo].[StorageLocations] ALTER COLUMN [UnitsStored] [int] NOT NULL
B. ALTER TABLE [dbo].[StorageLocations] [LocationDescription] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
C. ALTER TABLE [dbo].[StorageLocations] ALTER COLUMN [UnitsStored] [smallint] NOT NULL
D. ALTER TABLE [dbo].[StorageLocations] [LocationDescription] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

查看答案

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

更多问题

同一宗房地产，在不同的时间，其价值一般是不相同的。

A. 正确
B. 错误

查看答案

曾经荣获“人民艺术家”的称号的作家是()

A. 矛盾
B. 巴金
C. 老舍
D. 冰心

查看答案

The net-libraries on SQL2000 are configured as shown in the exhibit.
SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.
SQL2000 and SQL7 exchange confidential company information. You need to ensure that unauthorized users cannot access this information.
Which two actions should you take？ (Each correct answer presents part of the solution. Choose two)

A. On SQL2000, enable the multiprotocol net library.
B. On SQL2000, select the force protocol encryption check box.
C. On SQL7, select the force protocol encryption check box.
D. On SQL2000, install a secure sockets layer (SSL) encryption certificate.
E. On SQL2000 and SQL7, enable multiprotocol encryption.

查看答案

You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package.
You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take？ (Each correct answer represents part of the solution. Choose two.)

A. Save the DTS package so that it has an owner password.
B. Save the DTS package so that it has a user password.
C. Encrypt the DTS package details in the command line of the dtsrun utility.
D. Store the DTS package in the Meta. Data Services repository.
E. Store the DTS package as a Microsoft Visual Basic file.

查看答案