固镇县最贵的小区:有把握回答对的电脑高手来

6.在Windows Server 2003中，如果不使用第三方软件，下面（ ）只能在NTFS分区上实现。(选择四项)
A、磁盘配额
B、文件加密
C、卷影副本
D、文件压缩
E、文件共享
7.结构化布线工程中常采用4对UTP，它使用（ ）四种颜色标识。(选择一项)
A、紫、绿、蓝、棕
B、棕、蓝、黑、绿
C、橙、蓝、紫、绿
D、橙、绿、蓝、棕
8. 12) 数据库中包括两个表salesperson和orders，表定义如下：
CREATE TABLE Salesperson
(SalesPersionID int IDENTITY(1,1) NOTNULL PRIMARY KEY NONCLUSTERED,
RegionID int NOTNULL,
LastName varchar(30) NULL,
FirstName varchar(30) NULL,
MiddlName varchar(30) NULL,
AddressID int NULL)

CREATE TABLE Orders
(OrderID int IDENTITY(1,1) NOTNULL PRIMARY KEY NONCLUSTERED,
SalesPersonID int NOTNULL,
RegionID int NOTNULL,
OrderDate datetime NOTNULL,
OrderAmount money NOTNULL)
现在想得到2003年4月15日每个销售人员最高销售订单信息，信息中包含以下字段：Last Name、First Name、 Order Date、Order Amount。
（ ）可以实现此功能。(选择一项)
A、SELECT s.LastName,s.FirstName,o.OrderDate,MAX(OrderAmount)
FROM SalesPerson AS s
INNER JOIN Orders AS o
ON o.SalesPersonID=s.SalesPersonID
WHERE o.OrderDate=’04/15/2003’
AND OrderAmount in(select MAX(OrderAmount) from orders)
B、SELECT s.LastName,s.FirstName,o.OrderDate,MAX(OrderAmount)
FROM SalesPerson AS s
LEFT OUTER JOIN Orders AS o
ON o.SalesPersonID=s.SalesPersonID AND o.OrderDate=’04/15/2003’
GROUP BY s.LastName,s.FirstName,o.OrderDate
C、SELECT s.LastName,s.FirstName,o.OrderDate,OrderAmount
FROM SalesPerson AS s
LEFT OUTER JOIN Orders AS o
ON o.SalesPersonID=s.SalesPersonID
WHERE o.OrderDate=’04/15/2003’
AND OrderAmount in(select MAX(OrderAmount) from orders)
D、SELECT s.LastName,s.FirstName,o.OrderDate,MAX(OrderAmount)
FROM SalesPerson AS s
INNER JOIN Orders AS o
ON o.SalesPersonID=s.SalesPersonID
WHERE o.OrderDate=’04/15/2003’
GROUP BY s.LastName,s.FirstName,o.OrderDate,o.OrderID
请看清楚选项。有的是多选的``