Which mandatory clause has to be added to the following statement to successfully create an external table called EMPDET?

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.daf));

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.daf));

A.
TYPE

B.
REJECT LIMIT

C.
DEFAULT DIRECTORY

D.
ACCESS PARAMETERS



Leave a Reply 0

Your email address will not be published. Required fields are marked *