Oracle
1Z0-047 · Question #119
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))…
The correct answer is C. DEFAULT DIRECTORY. See the full explanation below for the reasoning.
Question
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));
Options
- ATYPE
- BREJECT LIMIT
- CDEFAULT DIRECTORY
- DACCESS PARAMETERS
How the community answered
(25 responses)- A8% (2)
- B16% (4)
- C72% (18)
- D4% (1)
Community Discussion
No community discussion yet for this question.