External Tables
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is an external table?
2. Which file formats are given as examples of externally stored data that external tables can query?
3. Which storage systems are named as examples of where external data files may reside?
4. What two things must be specified to create an external table?
5. In the CustomerData example, what does the LOCATION clause indicate?
6. How is an external table queried once it has been created?
7. Why are external tables described as cost-effective?
8. What does the HighValueCustomers example create?
9. What benefit does creating a view over an external table provide?
10. Which of the following is NOT a stated advantage of external tables?