ECDL Exam ECDL-ADVANCED Topic 2 Question 68 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 68
Topic #: 2

Which of the following join types results in the multiplication of the number of rows from the left table with the number of rows from the right table when it is used in an Access query?

AOuter join

BSelf join

CCross join

DInner join
Explanation:
When a cross join is used in a query, it results in the multiplication of the number of rows from the left table with the number of rows from the right table.
Answer option D is incorrect. In an inner join, data in various columns are compared by using the comparison operators. It is also known as equi-joins. The inner join returns only those rows that have an equal value.
Answer option A is incorrect. Outer joins are used to write a join that provides information about the mismatches or missing records. An outer join finds matches just like as an inner join, but also identifies the mismatches. With a suitable WHERE clause, an outer join can filter out matches to display only the mismatches.
Answer option B is incorrect. A self join is used to join a table with itself. In this case, a user will have to use two unique aliases for the table.

Show Suggested Answer

Suggested Answer: C

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

by Rosio at Apr 04, 2023, 12:31 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!