A database administrator wants to populate a database with large amounts of data from an external source.
Which of the following actions should be used to get the database populated?
Click on the arrows to vote for the correct answer
A. B. C. D.B.
The correct action to use to populate a database with large amounts of data from an external source is B. IMPORT.
An IMPORT operation is used to bring data from an external source into a database. This is typically used when the data already exists in a file or in another database and needs to be added to the current database. The IMPORT operation can be used to add data to an existing table or to create a new table.
On the other hand, the EXPORT operation is used to extract data from a database and save it to an external file or another database. This is typically used when you want to create a backup of the data or transfer it to another location.
SELECT and ALTER are SQL commands used to retrieve and modify data in a database respectively. SELECT is used to retrieve data from a table or multiple tables based on specified criteria, while ALTER is used to modify the structure of a table, such as adding or removing columns.
Therefore, the correct action to use to populate a database with large amounts of data from an external source is IMPORT.