1Z0-182 practice question 1 of 15

Which data dictionary view describes the data sources of external tables?

Full set: 94 questions

Answer options

A: DBA_ALL_USER_EXTERNAL_LOCATIONS Correct answer

B: DBA_ALL_USER_TAB_COLUMNS

C: DBA_ALL_USER_EXTERNAL_TABLES

D: DBA_ALL_USER_TABLES

Correct Answer:

A. DBA_ALL_USER_EXTERNAL_LOCATIONS

Explanation

The view EXTERNALLOCATIONS catalogs every file, URL, or other location that supplies data to an external table or external partition. The DBA form (and its ALL and USER synonyms) is therefore the data dictionary view that explicitly “describes the data sources of external tables.”

Why Incorrect

B. TABCOLUMNS lists column metadata; it contains no information about external‐table data sources.
C. EXTERNALTABLES contains definition metadata (type, default directory, access parameters) but not the individual data source locations.
D. TABLES is the general catalogue of relational tables; it has no external-table-specific columns.

References

1. Oracle Database Reference 23c, F85463-01, “DBAEXTERNALLOCATIONS – describes the data sources of external tables,” View Descriptions chapter, p. 3337.

2. Oracle Database Concepts 23c, F85456-01, chap. 21 “External Tables,” subsection “Data sources for external tables,” para. 2.

Keep practicing

Take the free 1Z0-182 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test