Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

ECDL Exam ECDL-ADVANCED Topic 3 Question 44 Discussion

Actual exam question for ECDL's ECDL ADVANCED WORD PROCESSING exam
Question #: 44
Topic #: 3

Which of the following statements will you use to copy data from one table named Department to another table named DepartmentID?

Show Suggested Answer Hide Answer
Suggested Answer: C

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'


Objective: Query Design

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!

Save Cancel