OCP-1Z0-051-V9.02-123题
来源:互联网 发布:迅雷看看mac版 编辑:程序博客网 时间:2024/05/19 17:56
123. View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
tables.
You need to generate a report that gives details of the customer's last name, name of the product, and
the quantity sold for all customers in ' Tokyo' .
Which two queries give the required result? (Choose two.)
A. SELECT c.cust_last_name,p.prod_name, s.quantity_sold
FROM sales s JOIN products p
USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';
B. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s JOIN customers c
ON(p.prod_id=s.prod_id)
ON(s.cust_id=c.cust_id)
WHERE c.cust_city='Tokyo';
C. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s
ON(p.prod_id=s.prod_id)
JOIN customers c
ON(s.cust_id=c.cust_id)
AND c.cust_city='Tokyo';
D. SELECT c.cust_id,c.cust_last_name,p.prod_id, p.prod_name, s.quantity_sold
FROM products p JOIN sales s
USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';
Answer: AC- OCP-1Z0-051-V9.02-123题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-11题
- OCP-1Z0-051-V9.02-12题
- OCP-1Z0-051-V9.02-14题
- OCP-1Z0-051-V9.02-15题
- OCP-1Z0-051-V9.02-17题
- OCP-1Z0-051-V9.02-18题
- OCP-1Z0-051-V9.02-21题
- OCP-1Z0-051-V9.02-118题
- OCP-1Z0-051-V9.02-120题
- OCP-1Z0-051-V9.02-32题
- OCP-1Z0-051-V9.02-33题
- OCP-1Z0-051-V9.02-93题
- OCP-1Z0-051-V9.02-94题
- OCP-1Z0-051-V9.02-95题
- 黑马程序员_<<基础加强--1.5新特性(泛型)(下)>>
- 字符串专项:LA 3490
- 移动技术
- vc6.0画走势图、折线图、饼状图的准备工作
- Wine QQ 2012 ibus中文输入解决方案
- OCP-1Z0-051-V9.02-123题
- 实现自己的mystring.h
- J2SE学习笔记:J2SE重点难点,TreeSet比较器
- Linux新手入门:通过chmod改变文件权限
- TCP SOCKET recv的内存情况
- 漫谈大数据仓库与挖掘系统
- UVA - 11027 Palindromic Permutation
- MODPOST 0 modules的解决办法
- 2013-10-19第一次去招聘市场面试