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

Oracle认证考试

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

Which two statements about subqueries are true? ()

  • A、A single row subquery can retrieve data from only one table.
  • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
  • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
  • D、A single row subquery can retrieve data from more than one table.
  • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
  • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
正确答案:B,D
答案解析:
进入题库查看解析

微信扫一扫手机做题