ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-119

047-119

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 09:28:45 0 删除 编辑
119. View the Exhibit and examine the data in the PRODUCT_INFORMATION table.
Which two tasks would require subqueries? (Choose two.)
A. displaying the minimum list price for each product status
B. displaying all supplier IDs whose average list price is more than 500
C. displaying the number of products whose list prices are more than the
average list price
D. displaying all the products whose minimum list prices are more than the
average list price of products having the product status orderable
E. displaying the total number of products supplied by supplier 102071 and
having product status OBSOLETE
Answer: CD
快速定位,需要跟平均值比较,要子查询的,B容易干扰判断

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718927/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-118
下一篇: 047-120
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203403