更多"[单选题]现有产品表Product,包含字段price(价格),pro"的相关试题:
[单选题]现有产品表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
[单选题]现有书目表book,包含字段:价格price ,类别名称typeName; 现在查询各个类别的平均价格、类别名称,以下语句正确的是()。
A.select avg(price),type from book group by typeName
B.select count(price),type from book group by typeName
C.select avg(price),type from book group by typeName
D.select count (price),type from book group by typeName
[单选题]现有书目表book,包含字段:价格price (float),类别type(char); 现在查询各个类别的平均价格、类别名称,以下语句正确的是(选一项)
A.select avg(price),type from book group by type
B.select count(price),type from book group by price
C.select avg(price),type from book group by price
D.select count (price),type from book group by type
[单选题]现有书目表book,包含字段:price (float); 现在查询一条书价最高的书目的详细信息,以下语句正确的是(选一项)
A.select top 1 * from book order by price asc
B.select top 1 * from book order by price desc
C.select top 1 * from book where price
D.select top 1 * from book where price= max(price)
[单选题]现有手机表Phone,包含字段:p_price(手机价格),p_id(手机编号),p_brand(手机品牌),计算每个品牌的手机数量,正确的SQL是()。
A.SELECT p_brand,COUNT(p_id) FROM Phone GROUP BY p_id
B.SELECT p_brand,COUNT(p_id) FROM Phone GROUP BY p_brand
C.SELECT p_brand,COUNT(p_id) FROM Phone GROUP BY p_price
D.SELECT p_brand,COUNT(p_id) FROM Phone ORDER BY p_brand
[多选题]现有图书表book,包含字段:price(decimal(6,2));现查询书价最高的图书信息,正确语句是()。【选两项】
A.select top 1 * from book order by price asc
B.select top 1 * from book order by price desc
C.select top 1 * from book where price=max(price)
D.select top 1 * from book where price=(select max(price) from book)
[单选题]现有课程表course,包含字段:c_id(课程编号),c_name(课程名称),c_date(开课日期),查询course表中的前5行,正确的语法是()。
A.select top 5 * from course
B.select top(5) from course
C.select top 5 from course
D.select top(5*) from course
[单选题]现有分数表score,包含字段:s_id(编号),c_id(科目编号),s_score(分数),哪条SQL()可以正确查询查询平均成绩大于60分的学生的学号和平均成绩
A.SELECT s_id,AVG(s_score)
FROM score
GROUP BY s_id
HAVING AVG(s_score)>60;
B.SELECT s_id,AVG(s_score)
FROM score
GROUP BY s_id
AND AVG(s_score)>60;
C.SELECT s_id,AVG(s_score)
FROM score
ORDER BY s_id
HAVING AVG(s_score)>60;
D.SELECT s_id,AVG(s_score)
FROM score
GROUP BY c_id
HAVING AVG(s_score)>60;
[单选题]现有汽车销售表c_orders,包含字段:c_id(订单编号),c_date(订单日期),c_price(订单金额),c_customer(客户姓名),可以查找每个客户总金额的是()。
A.SELECT c_customer,SUM(c_price) FROM c_orders
GROUP BY c_customer
B.SELECT c_customer,SUM(c_price) FROM c_orders
GROUP BY c_id
C.SELECT c_customer,COUNT(c_price) FROM c_orders
GROUP BY c_customer
D.SELECT c_customer,SUM(c_price) FROM c_orders
Order BY c_customer
[单选题]现有表book,字段:id (int),title (varchar), price (float); 其中id字段设为标识, 使用insert语句向book表中插入数据,以下语句错误的是(选一项)
A.insert into book (id,title,price) values(1,'java',100)
B.insert into book (title,price) values('java',100)
C.insert into book values ('java',100)
D.insert book values('java',100)
[单选题]在 MySQL 中,一个包含10个字段的表与一个包含5个字段的表进行交叉连接,生成的笛卡尔积的总字段数量是()。
A.15
B.50
C.不确定,这取决于有多少重名字段
D.100000
[单选题]现有教师表teacher,包含字段:t_id(教师编号),t_name(教师姓名),下列哪条SQL()可以正确查询姓“王”的老师的个数
A.SELECT SUM(t_id)
FROM teacher t
WHERE t_name LIKE '王%'
B.SELECT COUNT(t_id)
FROM teacher t
WHERE t_name LIKE '王%'
C.SELECT COUNT(t_id)
FROM teacher t
WHERE t_name = '王%'
D.SELECT COUNT(t_id)
FROM teacher t
WHERE t_name LIKE '王_'
[单选题]假设“产品”表中有“产品ID”,“产品名称”,“价格”此三个字段,要在此表里添加一条新记录,下列SQL语句能实现添加功能的是(选一项)
A.UPDATE INSERT 产品 VALUES('01008','花生','20')
B.INSERT 产品 VALUES(01008,花生,20)
C.INSERT INTO 产品 VALUES('01008','花生','20')
D.INSERT * FROM 产品 VALUES('01008','花生','20')
[判断题]为节省存储空间,定义表时应该将可能包含NULL值的字段放在字段列表的末尾。( )
A.正确
B.错误
[单选题]现有水果表 Fruit,其字段有:sale(销量),id(水果编号),price(价格),查询水果表总销量的SQL是()。
A.SELECT sum(sale) FROM Fruit;
B.SELECT count(sale) FROM Fruit;
C.SELECT max(sale) FROM Fruit;
D.SELECT min(sale) FROM Fruit;
[单选题]现有饮料表drink,其字段有:id(饮料编号),price(饮料价格),name(饮料名称)下列()语句查询结果为饮料最低价格。
A.select max(price) from drink
B.select min(price) from drink
C.select avg(price) from drink
D.select sum(price) from drink
[单选题] 在SQL Server 2005中, 有students (学生)表, 包含字段: STD(学号),SName (姓名), Grade (成绩). 现查找所有学员中成绩最高的前5名学员. 下列SQL语句正确的是(选一项)
A.SELECT TOP 5 FROM students ORDER BY Grade DESC
B.SELECT TOP 5 FROM students ORDER BY Grade
C.SELECT TOP 5 * FROM students ORDER BY Grade ASC
D.SELECT TOP 5 * FROM students ORDER BY Grade DESC
[判断题]复合主键不能包含不必要的多余字段
A.正确
B.错误
[单选题]在SQL Server中 有student(学生)表,包含字段:Sid(学号),SName(姓名),Score(成绩),现要将所有学生的成绩加10分,下列SQL语句正确的是()。
A.Update student set Score=Score+10 where Sid=1
B.Update * set Score=Score+10
C.Update * from student set Score=Score+10
D.Update student set Score=Score+10