Which of the following statements will you use to copy data from one table named Department to another table named DepartmentID?
You will use the following statement to copy data from one table named Department to another table named DepartmentID:
INSERT INTO DepartmentID SELECT * FROM Department
This statement will copy all data from the Department table to the DepartmentID table. The column names and the datatypes of both the tables must be the same.
The INSERT statement is used to insert data into a table. You can insert all data or only selected records from a table to another.
Answer options D, A, and B are incorrect. These are not valid statements for accomplishing the task. Reference: ECDL/ICDL Exam Course Manual, Contents: 'Copy data from one table to another'
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design