OCP-1Z0-051-V9.02-10题
来源:互联网 发布:java开源管理系统 编辑:程序博客网 时间:2024/05/22 00:19
10. View the Exhibit; e xamine the structure of the PROMOTIONS table.
Each promotion has a duration of at least seven days .
Your manager has asked you to generate a report, which provides the weekly cost for each promotion
done to l date.
Which query would achieve the required result?
A. SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7
FROM promotions;
B. SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7
FROM promotions;
C. SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7)
FROM promotions;
D. SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7)
FROM promotions;
Answer: D
答案解析:
提要要求:报表提供促销期间每周的成本
D,正确,符合题意。
AB C语法错误
sh@TEST0924> SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM promotions;
SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM promotions
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
sh@TEST0924> SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions;
SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
sh@TEST0924> SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions;
SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
- OCP-1Z0-051-V9.02-10题
- OCP-1Z0-051-V9.02-10题
- 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题
- JavaScript调试
- 数组在PHP内核中的实现
- 建议计算器
- OCP-1Z0-051-V9.02-9题
- MVC的职责分工
- OCP-1Z0-051-V9.02-10题
- OCP-1Z0-051-V9.02-11题
- 最小生成树-prime-jobdu-1017
- OCP-1Z0-051-V9.02-12题
- OCP-1Z0-051-V9.02-13题
- OCP-1Z0-051-V9.02-14题
- 黑马程序员-Java基础知识8(部分笔记总结-IO流)
- 关于dll文件的生成以及找不到jni.h的解决办法(fatal error C1083: Cannot open include file: 'jni.h':)
- OCP-1Z0-051-V9.02-15题