T-SQL 即 Transact-SQL，是 SQL 在 Microsoft SQL Server 上的增强版。（）

A.ANSI-99

B.ANSI-92

C.ANSI-86

D.ANSI-2008

关于SQL(Structured Query Language )和T-SQL语言，下列说法正确的是()。

A.SQL和T-SQL具有相同的功能，只是提出的公司不同。

B.Transact-SQL (T-SQL)是微软遵循 ANSI SQL 标准在Microsoft SQL Server 系统中使用的语言，增加了数据库编程功能。

C.SQL也是一种国际标准，适用于所有的数据库管理系统。

D.结构化查询语言 SQL是关系数据库管理系统的标准语言， 是一种国际标准， 用于数据库的创建、数据查询、数据更新等操作。 E.T-SQL 也是一种标准，适用于所有的数据库管理系统。

YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008EnterpriseEditioninstance.ThereisadatabasenamedDB1intheinstance.AbackupofDB1isperformedeveryday.YouhavetominimizethesizeofthefulldatabasebackupfilesofDB1.Intheoptionsbelow,whichTransact-SQLstatementshouldyouuse?（）

A.BACKUPDATABASEDB1TODISK='t:\backups\db1.bak';

B.BACKUPDATABASEDB1TODISK='t:\backups\db1.bak'WITHCOMPRESSION;

C.BACKUPDATABASEDB1TODISK='t:\backups\db1.bak'WITHDIFFERENTIAL;

D.BACKUPDATABASEDB1TODISK='t:\backups\db1.bak'WITHCOMPRESSION,DIFFERENTIAL;

YouarecreatingaSQLServer2005databaseforamortgagecompany.ThedatabasewillsupportanewWeb-basedapplicationthatwillhandleupto1，000simultaneoususers.Thisapplicationmustquicklydisplaytheresultsofcalculation-intensiveoperations，suchascalculatingmortgagepaymentsandamortizationschedules.Youneedtoensurethatthedatabaseprocessescalculationsasquicklyandefficientlyaspossible.Whatshouldyoudo？（）

A.ImplementparameterizedTransact-SQLqueriesintheapplication.

B.ImplementTransact-SQLstoredproceduresinthedatabase.

C.ImplementCLRstoredproceduresinthedatabase.

D.ImplementdistributedWebservices.

YouarecreatingaSQLServer2005databaseforamortgagecompany.ThedatabasewillsupportanewWeb-basedapplicationthatwillhandleupto1,000simultaneoususers.Thisapplicationmustquicklydisplaytheresultsofcalculation-intensiveoperations,suchascalculatingmortgagepaymentsandamortizationschedules.Youneedtoensurethatthedatabaseprocessescalculationsasquicklyandefficientlyaspossible.Whatshouldyoudo?（）

A.ImplementparameterizedTransact-SQLqueriesintheapplication.

B.ImplementTransact-SQLstoredproceduresinthedatabase.

C.ImplementCLRstoredproceduresinthedatabase.

D.ImplementdistributedWebservices.

You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the database to store the sales department’s responses to requests for price quotations. The database is configured as shown in the exhibit.

Developers in your company create an application used for saving quotations. The application executes the following transact-SQL statement:

UPDATE QuotationSummary

SET CustomerName = ‘Jean-Paul Deloria’

WHERE QuotationID = 12

When the application executes the statement, the developers receive the following error:

Server: Mrh4403, Level 16, Stats 1, Line 1

View or function ‘QuotationSummary’ is not updateable because it contains aggregates:

You want developers to be able to use this UPDATE statement without generating errors. What should you do?

A．Create an INSTEAD OF trigger on the view to update the composite tables.

B．Grant the developers UPDATE permissions on each base table.

C．Add a cascading update trigger on each base table.

D．Create a QuotationSummary table and populate the table with data from the base tables.

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. Users report that several storage locations in the UnitsStored field contain negative numbers. You examine the database's table structure. The table properties are configured as shown in the exhibit.

You correct all the negative numbers in the table. You must prevent the database from storing negative numbers. You also want to minimize use of server resources and physical I/O.

Which transact-SQL statement should you execute?

A．ALTER TABLE dbo.storagelocations ADD CONSTRAINTS CK_storagelocations_UnitsStored CHECK (UnitsStored>= 0)

B．CREATE TRIGGER CK_UnitsStored On StorageLocations FOR INSERT, UPDATE AS IF INSERTED, UnitsStored < 0 ROLLBACK TRAN

C．CREATE TABLE ck_unitsstored As @Units >= 0 GO Sp_bindrule ‘OK_UnitsStored’, ‘StorageLocations, UnitsStored’ GO

D．CREATE PROC UpdateUnitsStored (StorageLocationID int, @UnitsStored bigint)AS IF @UnitsStored < 0 DATSERROR (50099, 17) ELSE UPDATE storaheLocations SET UnitsStored = @UnitsStored WHERE StorageLocationID = @storageLocationID