Exit 1Z0-082 Oracle DBA Administration I
Question 3 of 5
0% complete
Q3 Multiple choice

Which two are benefits of external tables? (Choose two.)

Select all that apply.

  • A

    They support DELETES which transparently deletes records in the file system as if they were table

    rows.

  • B

    They can be queried, transformed, and joined with other tables without having to load the data first.

  • C

    They support UPDATES which transparently updates records in the file system as if they were table rows.

  • D

    The results of a complex join or aggregating function or both can be unloaded to a file for transportation to another database.

  • E

    They can be queried while the database is in the MOUNT state like dynamic performance views.