ECDL Exam ECDL-ADVANCED Topic 7 Question 54 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 54
Topic #: 7

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 Alishia at Jun 29, 2022, 12:26 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

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