EMPDET is an external table containing the columns EMPNO and ENAME. Which
command would work in relation to the EMPDET table?
A.
CREATE VIEW empvu AS SELECT* FROM empdept;
B.
CREATE INDEX empdet_dx ON empdet(empno);
C.
DELETE FROM empdet WHERE ename LIKE ‘J%’;
D.
UPDATE empdet SET ename = ‘Amit’ WHERE empno = 1234;
Explanation:
The external tables feature is a complement to existing SQL*Loader functionality. It enables you to access data in external sources as if it were in a table in the database.external tables were read-only.
A !!
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm
From Oracle Document:
You can, for example, select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables.
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm