发布时间：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.........【阅读全文】
发布时间：2015-03-19 23:40:54
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. CREATE VIEW v3 AS SELECT * FROM SALES WHERE cust_id = 2034 WITH CHECK OPTION; B. CREATE VIEW v1 AS.........【阅读全文】
发布时间：2015-03-19 23:08:14
1. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables. The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table. Similarly, the CUST_ID and TIME.........【阅读全文】
