ECDL Exam ECDL-ADVANCED Topic 8 Question 96 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 96
Topic #: 8

[All ECDL-ADVANCED Questions]

Which of the following statements will you use to delete a table from a database?

ADROP TABLE <table_name>

BDELETE TABLE <table_name> FROM DATABASE

CREMOVE TABLE <table_name>

DDELETE TABLE <table_name>

Show Suggested Answer

Suggested Answer: C

When James opens a text file in Microsoft Access, a new database is created and a linked table is created in the new database after the Finish button is clicked in the wizard. The database is created with the same name as that of the text file. The wizard provides an option of renaming the table. The default name of the table is same as that of the text file.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data

by Marica at Sep 06, 2024, 02:02 PM

Limited Time Offer

25%

Off

Get Premium ECDL-ADVANCED Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Garry

10 months ago

I'd go with D. Linking the text file to an existing database is the most straightforward approach here.

upvoted 0 times

...

Tyisha

11 months ago

Haha, I bet James will accidentally create a new database and be really confused when he can't find his Sales database anymore. Option C is a classic IT blunder!

upvoted 0 times

Carrol

9 months ago

Haha, I bet James will accidentally create a new database and be really confused when he can't find his Sales database anymore. Option C is a classic IT blunder!

upvoted 0 times

...

Johana

9 months ago

B) The data is copied into a new table and is not affected if there is a change of data in the text file.

upvoted 0 times

...

Buck

10 months ago

A) Data of the text file is appended to an existing table and gets affected if there is a change of data in the text file.

upvoted 0 times

...

Evangelina

11 months ago

I'm not sure, but I think A could also be a possibility.

upvoted 0 times

...

Annamae

11 months ago

I think B is the correct answer. You don't want the data in the text file to affect the existing table, so copying it into a new table is the way to go.

upvoted 0 times

...