Answer 1

There are some utilities available with each database to import and export data. For example, you can use sqlldr to import data from file into Oracle and you can use sqlplus to export the results in a file in Oracle. In Teradata, you can use bteq utility to import and export data.