Which Utility used to copy a table and restore it to another database?
-
BTEQ
-
Archive Recovery
-
Table rebuild
-
FastLoad
Archive/Recovery utility is designed to copy tables (archive) and restore them to another database (recovery). BTEQ is for query processing, Table rebuild is for rebuilding damaged tables, and FastLoad is for high-speed initial data loading into empty tables.
In Teradata, the Archive/Recovery (ARC) utility is used to back up (archive) a table or database and restore/copy it — including onto a different Teradata system/database — making it the tool for copying a table and restoring it elsewhere. BTEQ is a query/scripting tool for running SQL and batch jobs, not a backup/copy utility; FastLoad is for bulk-loading data into empty tables from flat files, not for database-to-database table copies; "Table rebuild" isn't a Teradata utility name.