更多"[判断题]. (判断题,)Products such as refin"的相关试题:
[单选题] There___a lot of sugar in the ja
A. has
B.are
C.is
D. were
[单选题]If you give away a box of sugar, you( ).。
A.give it to each person
B. sell it to different people
C.borrow it from another person
D.lend it to others
[判断题]
Products sell well when their attributes match consumer needs.
A.正确
B.错误
[判断题]. (判断题,)Products such as electronic components and pharmaceuticals have low value-to-weight ratios.
A.正确
B.错误
[单选题]现有产品表Products,包含字段:UnitPrice(商品单价),ProductId(产品编号),ProductName(商品名称),ProductClass(产品类别),从产品表Products中查询单价UnitPrice最高的商品单价,正确的SQL是()。
A.SELECT MIN (UnitPrice) AS 最高单价 FROM Products
B.SELECT AVG (UnitPrice) AS 最高单价 FROM Products
C.SELECT MAX (UnitPrice) AS 最高单价 FROM Products
D.SELECT MAX UnitPrice AS 最高单价 FROM Products
[单选题]在SQL Server数据库中,你想得到在products表中最贵的产品名称和价格应该使用的正确查询是(选一项)
A.SELECT TOP 1 Productname, Price FROM Products ORDER BY Price
B.SELECT Productname, MAX(Price)FROM Products
C.SELECT TOP 1 Productname, Price FROM Products ORDER BY Price DESC
D.SELECT Productname, MAX(Price)FROM Products GROUP BY Productname
[多选题]从产品表Products中查询单价UnitPrice在6~10的产品名称和单价信息,正确的SQL有()。【选两项】
A.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.SELECT Name,UnitPrice FROM Products WHERE UnitPrice IN( 6,10)
D.SELECT Name,UnitPrice FROM Products WHERE UnitPrice>= 6 AND UnitPrice <=10
[单选题]从产品表Products中查询前10行商品的单价UnitPrice之和,正确的SQL是()。
A.SELECT TOP 10 SUM(UnitPrice) AS 单价之和 FROM Products
B.SELECT SUM(UnitPrice) AS 单价之和 TOP 10 FROM Products
C.SELECT TOP 10 COUNT(UnitPrice) AS 单价之和 FROM Products
D.SELECT SUM(UnitPrice) TOP 10 AS 单价之和FROM Products
[单选题]下列()语句,是对商品表Products,查询商品名称和商品单价,要求商品单价四舍五入保留整数。
A.SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products
B.SELECT ProductName, ROUND(UnitPrice,1) as UnitPrice FROM Products
C.SELECT ProductName, ROUND(UnitPrice,2) as UnitPrice FROM Products
D.SELECT ProductName, (UnitPrice,0) as UnitPrice FROM Products