J&C

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

全部博文(14)

文章存档

2018年(7)

2017年(6)

2016年(1)

我的朋友

发布时间:2018-06-12 17:58:27

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.........【阅读全文】

阅读(3) | 评论(0) | 转发(0)

发布时间:2018-06-12 17:44:28

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.........【阅读全文】

阅读(3) | 评论(0) | 转发(0)

发布时间:2018-06-12 17:35:45

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.........【阅读全文】

阅读(2) | 评论(0) | 转发(0)

发布时间:2018-06-12 17:19:24

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.........【阅读全文】

阅读(3) | 评论(0) | 转发(0)

发布时间:2018-06-12 16:02:36

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.........【阅读全文】

阅读(4) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册