Which two operations can be performed on an external table? (Choose two.)

Question

Accepted Answer

A. Create a view on the table Views can be created on external tables because a view is simply a stored query definition and does not require the underlying table to support DML or physical storage structures. Oracle allows CREATE VIEW against external tables just as it does for regular tables. C. Create a synonym on the table A synonym is a database alias and requires no physical storage or DML capability on the target object, so CREATE SYNONYM is fully supported on external tables.

Answer

B. Create an index on the table Indexes cannot be created on external tables because external tables have no segment storage in the database and Oracle has no mechanism to maintain an index structure against externally stored data.

Answer

D. Add a virtual column to the table Virtual columns cannot be added to external tables; the ALTER TABLE...ADD (column AS expression VIRTUAL) syntax is not supported for external table objects.

Answer

E. Update the table using the UPDATE statement External tables are strictly read-only; the UPDATE statement is not supported and will return ORA-30657.

Answer

F. Delete rows in the table using the DELETE command External tables are strictly read-only; the DELETE statement is not supported and will return ORA-30657.

Which two operations can be performed on an external table? (Choose two.)

Question

Options

How the community answered

Why each option

Topics

Community Discussion