摘要:
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... 阅读全文
摘要:
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... 阅读全文
摘要:
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... 阅读全文
摘要:
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... 阅读全文
摘要:
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... 阅读全文
摘要:
6. Examine the structure of the SHIPMENTS table:name Null TypePO_ID NOT NULLNUMBER(3)PO_DATE NOT NULLDATESHIPMENT_DATE NOT NULLDATESHIPM... 阅读全文
摘要:
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... 阅读全文
摘要:
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... 阅读全文
摘要:
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... 阅读全文
摘要:
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.... 阅读全文
摘要:
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... 阅读全文