New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

ECDL Exam ECDL-ADVANCED Topic 7 Question 94 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 94
Topic #: 7

[All ECDL-ADVANCED Questions]

Which of the following statements will you use to eliminate duplicate contents in a table?

ASELECT...DISTINCT

BSELECT...WHERE

CSELECT...TOP

DSELECT...ALL
Explanation:
You will use the following statement to eliminate duplicate contents in a table:
SELECT...DISTINCT
Answer option D is incorrect. The SELECT...ALL statement is used to display all rows from a table, including duplicate rows.
Answer option C is incorrect. The SELECT...TOP statement is used to display the first set of rows specified in the TOP clause.
Answer option B is incorrect. The SELECT...WHERE statement is used to filter the data in a table.
Reference: ECDL/ICDL Exam Course Manual, Contents: 'SELECT... DISTINCT'
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Query Design

Show Suggested Answer

Suggested Answer: A

by Sabina at Aug 02, 2024, 04:18 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Daniel

4 months ago

Haha, imagine if the answer was D) SELECT...ALL. That would just bring back all the duplicates we're trying to get rid of. Classic!

upvoted 0 times

Argelia

3 months ago

Yeah, SELECT...DISTINCT is the way to go to eliminate duplicates.

upvoted 0 times

...

Kasandra

4 months ago

I know, that would be counterproductive!

upvoted 0 times

...

...

Shaniqua

4 months ago

I knew it! SELECT...DISTINCT is the way to go. Eliminates those pesky duplicate rows like a charm.

upvoted 0 times

Kendra

3 months ago

SELECT...DISTINCT is definitely a useful statement for that.

upvoted 0 times

...

Jose

4 months ago

Absolutely! It's a great way to clean up your data.

upvoted 0 times

...

Chantay

4 months ago

I knew it! SELECT...DISTINCT is the way to go. Eliminates those pesky duplicate rows like a charm.

upvoted 0 times

...

...

Mary

5 months ago

I believe C) SELECT...TOP displays the first set of rows, not eliminate duplicates

upvoted 0 times

...

Marvel

5 months ago

I'm not sure, but I think D) SELECT...ALL shows all rows including duplicates

upvoted 0 times

...

Garry

5 months ago

A) SELECT...DISTINCT is definitely the correct answer. I've used that statement many times to get rid of duplicates in my database queries.

upvoted 0 times

Chantay

4 months ago

Yes, it's a useful statement for eliminating duplicates.

upvoted 0 times

...

Charolette

4 months ago

I agree, SELECT...DISTINCT is the way to go.

upvoted 0 times

...

...

Elin

5 months ago

I agree with Jenelle, SELECT...DISTINCT eliminates duplicate contents

upvoted 0 times

...

Jenelle

5 months ago

I think the answer is A) SELECT...DISTINCT

upvoted 0 times

...

az-700 pass4success az-104 200-301 200-201 cissp 350-401 350-201 350-501 350-601 350-801 350-901 az-720 az-305 pl-300

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77