发布时间：2015-03-20 01:18:14
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 promotiondone to l date. Which query would achieve the required result.........【阅读全文】
发布时间：2015-03-20 01:07:27
9. Which statement is true regarding the INTERSECT operator? A. It ignores NULL values. B. Reversing the order of the intersected tables alters the result. C. The names of columns in all SELECT statements must be identical. D. The number of columns and data types must be identical fo.........【阅读全文】
发布时间：2015-03-20 01:03:15
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 statement? (Choose two.) A. listing of customers who do not have a credit limit and were born before 1980 B. finding the number of customers, in.........【阅读全文】
发布时间：2015-03-20 00:44:29
7. Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.) A. Both USING and ON clauses can be used for equijoins and nonequijoins. B. A maximum of one pair of columns can be joined between two tables using the ON clause. C. The ON cl.........【阅读全文】
