ECDL Exam ECDL-ADVANCED Topic 3 Question 44 Discussion

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