2014年6月26日
OCP-1Z0-051-题目解析-第13题
摘要： 13. View the Exhibit and examine the structure of the PRODUCTS table.You need to generate a report in the following format:CATEGORIES5MP Digital Photo... 阅读全文
posted @ 2014-06-26 17:50 wjx515 阅读(1032) 评论(0) 推荐(0) 编辑
OCP-1Z0-051-题目解析-第12题
摘要： 12. You need to produce a report where each customer's credit limit has been incremented by $1000. Inthe output, the customer's last name should have ... 阅读全文
posted @ 2014-06-26 15:52 wjx515 阅读(621) 评论(0) 推荐(0) 编辑
2014年6月25日
OCP-1Z0-051-题目解析-第11题
摘要： 11. View the Exhibit and examine the structure of the PRODUCTS table.All products have a list price.You issue the following command to display the tot... 阅读全文
posted @ 2014-06-25 23:03 wjx515 阅读(466) 评论(0) 推荐(0) 编辑
OCP-1Z0-051-题目解析-第10题
摘要： 10. View the Exhibit and examine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days .Your manager has asked yo... 阅读全文
posted @ 2014-06-25 22:10 wjx515 阅读(242) 评论(0) 推荐(0) 编辑
OCP-1Z0-051-题目解析-第9题
摘要： 9. Which statement is true regarding the INTERSECT operator?A. It ignores NULL values.B. Reversing the order of the intersected tables alters the resu... 阅读全文
posted @ 2014-06-25 21:18 wjx515 阅读(271) 评论(0) 推荐(0) 编辑
OCP-1Z0-051-题目解析-第8题
摘要： 8. View the Exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single sta... 阅读全文
posted @ 2014-06-25 20:14 wjx515 阅读(326) 评论(0) 推荐(0) 编辑
OCP-1Z0-051-题目解析-第7题
摘要： 7. Which twostatements are true regarding the USING and ON clauses in table joins? (Choose two.)A. Both USING and ON clauses can be used for equijoins... 阅读全文
posted @ 2014-06-25 20:12 wjx515 阅读(287) 评论(0) 推荐(0) 编辑
OCP-1Z0-051-题目解析-第6题
摘要： 6. Examine the structure of the SHIPMENTS table:name Null TypePO_ID NOT NULLNUMBER(3)PO_DATE NOT NULLDATESHIPMENT_DATE NOT NULLDATESHIPM... 阅读全文
posted @ 2014-06-25 19:33 wjx515 阅读(388) 评论(0) 推荐(0) 编辑
OCP-1Z0-051-题目解析-第5题
摘要： 5. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .)A. SELECT TO_CHAR(1890.55,'$0G000D00')FROM DUAL;B. SELECT TO_CHA... 阅读全文
posted @ 2014-06-25 19:03 wjx515 阅读(292) 评论(0) 推荐(0) 编辑
OCP-1Z0-051-题目解析-第4题
摘要： 4. Which two statements are true regarding single row functions? (Choose two.)A. They a ccept only a single argument.B. They can be nested only to two... 阅读全文
posted @ 2014-06-25 18:54 wjx515 阅读(268) 评论(0) 推荐(0) 编辑
下一页