多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries? ()

  • 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
正确答案:C,D
答案解析:
进入题库查看解析

微信扫一扫手机做题