ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-056

047-056

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-18 09:29:47 0 删除 编辑
56. Which mandatory clause has to be added to the following statement to
successfully create an external table called EMPDET?
CREATE TABLE empdet
(empno CHAR(2), ename CHAR(5), deptno NUMBER(4))
ORGANIZATION EXTERNAL
(LOCATION ('emp.dat'));
A. TYPE
B. REJECT LIMIT
C. DEFAULT DIRECTORY
D. ACCESS PARAMETERS
Answer: C
Mandatory:强制 clause:条款
To create an external table, we’ll need to identify the location in the
operating system where the external file containing the table will reside.
01 CREATE TABLE INVOICES_EXTERNAL
02 ( INVOICE_ID CHAR(3),
03 INVOICE_DATE CHAR(9),
04 ACCOUNT_NUMBER CHAR(13)
05 )
06 ORGANIZATION EXTERNAL
07 (TYPE ORACLE_LOADER
08 DEFAULT DIRECTORY INVOICE_FILES
09 ACCESS PARAMETERS
10 (RECORDS DELIMITED BY NEWLINE
11 SKIP 2
12 FIELDS (INVOICE_ID CHAR(3),
13 INVOICE_DATE CHAR(9),
14 ACCOUNT_NUMBER CHAR(13))
15 )
16 LOCATION ('INVOICE_DATA.TXT')
17 );
57.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718840/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-054
下一篇: 047-061
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204333