Multiple choice technology databases

which madatory clause has to be added to the following statements successfully create an external table called EMPDET? CREATE TABLE EMPDET( empno CHAR(2) ,ename CHAR(5) ,deptno N?UMBER(4)) ORGANIZATION EXTERNAL ( LOCATION('emp.dat'));

  1. TYPE

  2. REJECT LIMIT

  3. ACESS PARAMETERS

  4. DEFAULT DIRECTORY
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

External tables in Oracle require a DEFAULT DIRECTORY clause to specify where the external data file is located. The LOCATION parameter points to the file, but DEFAULT DIRECTORY tells Oracle which directory object to use. Without it, Oracle cannot access the external file.

Keep practicing — related questions