发布时间：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.........【阅读全文】
发布时间：2015-03-20 00:02:41
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_CHAR(1890.55,'$9,999V99') FROM DUAL; C. SELECT TO_CHAR(1890.55,'$99,999D99') FROM DUAL; D. SELECT TO_CHAR(1890.55,'$99G999D00')&.........【阅读全文】
发布时间：2015-03-19 23:56:34
4. Which two statements are true regarding single row functions? (Choose two.) A. They accept only a single argument. B. They can be nested only to two levels. C. Arguments can only be column values or constants. D. They always return a single result row for every row of a queried table. E. The.........【阅读全文】
发布时间：2015-03-19 23:45:08
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 used in the SELECT statement to get.........【阅读全文】
