ECDL Exam ECDL-ADVANCED Topic 3 Question 84 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 84
Topic #: 3

You have created a database named Addresses by using Microsoft Access 2010. You want to maintain the uniqueness of rows in the table. Which of the following integrities will you use to accomplish this task?

AEntity

BDomain

CData

DReferential
Explanation:
Entity integrity enforces the uniqueness of rows in a table. The uniqueness of rows can be enforced by the identifier column(s) through indexes, UNIQUE constraints, PRIMARY KEY constraints, or IDENTITY properties.
Answer option D is incorrect. Referential integrity means that the foreign key in any referencing table must always refer to a valid row in the referenced table. Referential integrity ensures that the relationship between two tables remains synchronized during updates and deletes. For a foreign key to be valid, it must contain either the value NULL, or an existing key value from the primary or unique key columns referenced by the foreign key. To enforce referential integrity, a foreign key column link to the primary key column should be created in the related table.
Answer option C is incorrect. Data integrity is a mechanism that ensures that the data is not modified during transmission from source to destination. This means that the data received at the destination should be identical as that sent from the source. In order to maintain data integrity, the data values must be within a defined range and in the correct format. For example, the value of an employee's age must be within the range of 20-60 years, which means that the age cannot be below 20 years and more than 60 years.
Answer option B is incorrect. Domain integrity enforces data validity by restricting the data type, valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY constraints) for columns in a table.

Show Suggested Answer

Suggested Answer: A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

by Glory at Apr 11, 2024, 04:06 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Detra

5 months ago

Yeah, that's correct. Data integrity is more about ensuring data consistency during transmission.

upvoted 0 times

...

Theresia

5 months ago

I initially thought the answer was C) Data integrity, but now I see that it's about data transmission and not uniqueness of rows.

upvoted 0 times

...

Silvana

5 months ago

You're right, referential integrity ensures synchronization during updates and deletes.

upvoted 0 times

...

Earleen

5 months ago

But what about referential integrity? It's also important for maintaining relationships between tables.

upvoted 0 times

...

Detra

5 months ago

I agree, entity integrity enforces uniqueness of rows.

upvoted 0 times

...

Silvana

5 months ago

I think the answer is A) Entity integrity.

upvoted 0 times

...

Luisa

5 months ago

No, Referential integrity ensures relationship synchronization between tables, not uniqueness of rows.

upvoted 0 times

...

Marleen

6 months ago

But what about Referential integrity? Doesn't that also maintain uniqueness?

upvoted 0 times

...

Iraida

6 months ago

I agree with you. Entity integrity enforces uniqueness of rows.

upvoted 0 times

...

Johnna

7 months ago

I think the answer is A) Entity integrity.

upvoted 0 times

...

Oretha

7 months ago

I'm a bit confused about the other options though. Can we quickly go over why they are not the right choice for this scenario?

upvoted 0 times

...

Juan

7 months ago

I'm with you on that. The explanation also confirms that entity integrity is the appropriate choice to enforce the uniqueness of rows in a table.

upvoted 0 times

...

Aimee

7 months ago

Yes, that's correct. Entity integrity is the way to go here. The question specifically asks about maintaining the uniqueness of rows, and that's what entity integrity is all about.

upvoted 0 times

...

Alberta

7 months ago

Okay, let's start with option A. Entity integrity is about ensuring the uniqueness of rows in a table, right? That sounds like the right approach for maintaining the uniqueness of rows in the Addresses table.

upvoted 0 times

...

Lenny

7 months ago

Agreed. We need to make sure we have a solid grasp of the different types of integrity in database design.

upvoted 0 times

Jill

6 months ago

Referential integrity ensures foreign keys always refer to a valid row.

upvoted 0 times

...

Samuel

6 months ago

What about Referential integrity?

upvoted 0 times

...

Jules

6 months ago

That's correct. Entity integrity enforces uniqueness of rows in a table.

upvoted 0 times

...

Kattie

6 months ago

Entity

upvoted 0 times

...

Alaine

8 months ago

This question seems straightforward, but I want to make sure I understand the concepts properly. Let's go through each answer option and discuss why they are correct or incorrect.

upvoted 0 times

...