Which of the following statements about external tables is true?
A.
They can have constraints or triggers.
B.
They cannot be written to with DML commands.
C.
They can have indexes.
D.
They cannot be used in joins, views, and subqueries.
Explanation:
An external table is a read-only table stored outside a database in flat files. The metadata for an external table
is not created at the time of table creation. However, the CREATE TABLE statement is used to create
metadata. External tables are used to load and unload Oracle data as flat files. The following can be used to
query data stored in an external table:
SQL statements
PL/SQL
JAVA
Indexes cannot be created for an external table. The following are the two types of access drivers provided by
an Oracle server for an external table:ORACLE_LOADER (Loader access driver): It is used to read data from
external files by using Oracle Loader technology. The data format should be interpreted by SQL*Loader utility.
ORACLE_INTERNAL (Import/export access driver): It is used to import and export data. The import and export
operations are platform independent. Some additional characteristics of external tables are mentioned below:
They can be queried in a similar manner as internaltables.
They can be used in joins, views, and subqueries.
They cannot have indexes, constraints, or, triggers.
They cannot be written to with DML commands.
Note: It is possible to write to an external table with Data Pump.
Every as soon as in a while we decide on blogs that we study. Listed beneath are the most up-to-date web sites that we choose.
0
0
Just beneath, are quite a few entirely not associated web sites to ours, having said that, they may be certainly really worth going over.
0
0
here are some links to web-sites that we link to since we assume they are really worth visiting
0
0
we prefer to honor a lot of other web web-sites around the internet, even though they arent linked to us, by linking to them. Below are some webpages really worth checking out
0
0
Here are some of the web sites we suggest for our visitors
0
0
very few web sites that come about to become detailed beneath, from our point of view are undoubtedly effectively really worth checking out
0
0
below you will uncover the link to some web pages that we assume you should visit
0
0
please go to the sites we adhere to, which includes this 1, as it represents our picks through the web
0
0
we prefer to honor numerous other net internet sites on the net, even if they arent linked to us, by linking to them. Below are some webpages really worth checking out
0
0
although web sites we backlink to below are considerably not related to ours, we feel they’re truly worth a go by way of, so have a look
0
0