摘要：
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
阅读(470)
评论(0)
推荐(0)
摘要：
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
阅读(252)
评论(0)
推荐(0)
摘要：
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
阅读(279)
评论(0)
推荐(0)
摘要：
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
阅读(331)
评论(0)
推荐(0)
摘要：
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
阅读(295)
评论(0)
推荐(0)
摘要：
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
阅读(392)
评论(0)
推荐(0)
摘要：
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
阅读(305)
评论(0)
推荐(0)
摘要：
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
阅读(279)
评论(0)
推荐(0)
摘要：
3. You need to extract details of those products in the SALES table where the PROD_ID columncontains the string '_D123'.Which WHERE clause could be u... 阅读全文
posted @ 2014-06-25 18:02
wjx515
阅读(198)
评论(0)
推荐(0)
摘要：
2. View the Exhibit to examine the description for the SALES table.Which views can have all DML operations performed on it? (Choose all that apply.)A.... 阅读全文
posted @ 2014-06-25 17:53
wjx515
阅读(462)
评论(0)
推荐(0)
摘要：
1. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMEStables.The PROD_ID column is the foreign key in the SALES ta... 阅读全文
posted @ 2014-06-25 16:59
wjx515
阅读(817)
评论(0)
推荐(0)
浙公网安备 33010602011771号