• 博客访问： 15504
• 博文数量： 14
• 用 户 组： 普通用户
• 注册时间： 2014-05-12 16:16

2018年（7）

2017年（6）

2016年（1）

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.)观察下面的表结构, 哪儿个任务需要在一个语句中包含子查询或者joinsA. listing of customers who do not have a credit limit and wer.........【阅读全文】

7. Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)   关于USING和ON子句, 哪儿个是正确的A. Both USING and ON clauses can be used for equijoins and nonequijoins.     --using不能用于不等值连接B. A maximum of one pair of columns.........【阅读全文】

6. Examine the structure of the SHIPMENTS table:    检查表SHIPMENTS 的结构name Null TypePO_ID NOT NULL NUMBER(3) PO_DATE NOT NULL DATESHIPMENT_DATE NOT NULL DATE SHIPMENT_MODE VARCHAR2(30) SHIPMENT_COST NUMBER(8,2)You want to generate a report that displays the PO_ID and the penal.........【阅读全文】

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') FROM DUAL;E. S.........【阅读全文】

4. Which two statements are true regarding single row functions? (Choose two.) --下列关于简单函数描述正确的是A. They accept only a single argument.             --select concat('a','b') from dual; B. They can be nested only to two levels.       &nb.........【阅读全文】