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.dat’));

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



Leave a Reply 3

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


user

user

DEFAULT DIRECTORY is needed to specify the external source table’s location.

Google

Google

Very few sites that take place to become in depth beneath, from our point of view are undoubtedly effectively worth checking out.

seenagape

seenagape

Correct answer is C