OCP认证051考试题库:11g-v9.02-第153题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询OCP认证051考试题库:11g-v9.02-第153题,完整题库请点击这里联系老师咨询了解
153. View the Exhibits and examine the structures of the PRODUCTS and SALES tables.
Which two SQL statements would give the same output? (Choose two.)
A. SELECT prod_id FROM products
INTERSECT
SELECT prod_id FROM sales;
B. SELECT prod_id FROM products
MINUS
SELECT prod_id FROM sales;
C. SELECT DISTINCT p.prod_id
FROM products p JOIN sales s
ON p.prod_id=s.prod_id;
D. SELECT DISTINCT p.prod_id
FROM products p JOIN sales s
ON p.prod_id <> s.prod_id;
Answer: AC
试题解析:
A:所有的产品和已卖出的产品相交,即返回已经卖出去的产品的id。
B:所有的产品和已卖出去的产品相减,即返回没有卖出去的产品。
C:返回已卖出去的产品的id
D答案:会把所有的都显示出来
INTERSECT Example The following statement combines the results with the INTERSECT operator, which returns only those unique rows returned by both queries
返回共同有的唯一的行
MINUS Example The following statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second
返回第一个有,第二个表无的行