创建一个名为‘Customers’的新表，同时要求新表中包含表‘clients’的所有记录，sql语句是()

A.SELECT，从一个或多个表中检索某些记录

B.CREATE，创建一个新的表，一个表的视图，或者数据库中的其他对象

C.INSERT，创建一条记录

D.DELETE，删除整个表，或者表的视图，或者数据库中的其他对象

A.在表上创建一个视图

B.用UPDATE语句更新使表

C.在表上创建一个索引

D.虚拟列添加到表中

E.在表上创建的同义词

A.SHOWtablename

B.SHOWsqlscripttablename

C.SHOWCREATETABLEtable_name

A、创建语句：USE northwindGO CREATE PROCEDURE dbo. FindCustomer$CustomerID char(5)LIKESELECT contactName From Customers WHERE CustomerID=$CustomerID调用语句EXEC northwind.dbo. FindCustomer$CustomerID= ‘thecr’

B、创建语句：USE northwindGO CREATE PROCEDURE dbo. FindCustomer@CustomerID char(5)ASSELECT contactName From Customers WHERE @CustomerID=CustomerID调用语句EXEC northwind.dbo. FindCustomer@CustomerID= ‘thecr’

C、创建语句：USE northwindGO CREATE PROCEDURE dbo. FindCustomer@CustomerID char(5)ASSELECT contactName From Customers WHERE CustomerID=@CustomerID调用语句EXEC northwind.dbo. FindCustomerCustomerID= ‘thecr’

D、创建语句：USE northwindGO CREATE PROCEDURE dbo. FindCustomer@CustomerID char(5)LIKESELECT contactName From Customers WHERE CustomerID=@CustomerID调用语句EXEC northwind.dbo. FindCustomer@CustomerID= ‘thecr’

A．A．DROP

B．B．ALTER

C．

C．UPDATE

D．

D．DELETE

A.host权限表

B.table_priv权限表

C.db权限表

D.user权限表

你管理一个SQL Server 2008数据库，其中包含名为dbo.Sales的表，该表包含下面的表定义：

CREATE

TABLE [dbo].[Sales]([SalesID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY

CLUSTERED,[OrderDate] [datetime] NOT NULL,[CustomerID] [int] NOT

NULL,[SalesPersonID] [int] NULL,[CommentDate] [date] NULL);

此表包含数百万条订单。你运行下面的查询来确定销售人员何时在dbo.Sales表中提供备注：

SELECT SalesID,CustomerID,SalesPersonID,CommentDate FROM dbo.SalesWHERE CommentDate IS NOT NULL AND SalesPersonID IS NOT NULL;

你发现此查询运行很慢。检查数据之后，你发现只有1%的行有备注日期，10%的行的SalesPersonID为null。你需要创建索引来优化此查询。索引必须在优化查询的同时节省磁盘空间。应创建哪个索引（）？

A.CREATE NONCLUSTERED INDEX idx1 ON dbo.Sales (CustomerID) INCLUDE (CommentDate)WHERE SalesPersonID IS NOT NULL;

B.CREATE NONCLUSTERED INDEX idx1 ON dbo.Sales (SalesPersonID) INCLUDE (CommentDate,CustomerID);

C.CREATE NONCLUSTERED INDEX idx1 ON dbo.Sales (CustomerID) INCLUDE(CommentDate,CustomerID);

D.CREATE NONCLUSTERED INDEX idx1 ON dbo.Sales (CommentDate, SalesPersonID) INCLUDE(CustomerID) WHERE

CommentDate IS NOT NULL;