ECDL Exam ECDL-ADVANCED Topic 8 Question 104 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 104
Topic #: 8

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 Louann at Dec 08, 2024, 05:33 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Joanna

9 months ago

I'm pretty sure the answer is 'All of the above'. How else are we supposed to keep this database in tip-top shape?

upvoted 0 times

Daron

9 months ago

Data integrity ensures that the data is not modified during transmission from source to destination.

upvoted 0 times

...

Lyndia

9 months ago

Referential integrity ensures that the relationship between two tables remains synchronized during updates and deletes.

upvoted 0 times

...

Lettie

9 months ago

Entity integrity enforces the uniqueness of rows in a table.

upvoted 0 times

...

Cammy

9 months ago

Data integrity? Domain integrity? Nah, this is all about that sweet, sweet entity integrity. The one true integrity to rule them all!

upvoted 0 times

Paulina

8 months ago

Domain integrity is more about data validity, entity integrity is all about uniqueness.

upvoted 0 times

...

Nidia

9 months ago

Data integrity is important too, but for uniqueness, entity integrity is key.

upvoted 0 times

...

Elfriede

9 months ago

Yeah, entity integrity ensures that each row is unique.

upvoted 0 times

...

Lorrie

9 months ago

Entity integrity is the way to go for maintaining uniqueness in the table.

upvoted 0 times

...

Maurine

10 months ago

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

upvoted 0 times

...

Catarina

10 months ago

Wait, did someone just say 'All of the above'? I thought this was a multiple-choice exam, not a 'pick every option' kind of deal.

upvoted 0 times

Franklyn

9 months ago

D) Referential

upvoted 0 times

...

Emmett

9 months ago

C) Data

upvoted 0 times

...

Kati

9 months ago

B) Domain

upvoted 0 times

...

Frankie

9 months ago

A) Entity

upvoted 0 times

...

Julie

10 months ago

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

upvoted 0 times

...

Cristal

10 months ago

Ah, the good old entity integrity. Keeping those rows unique like a boss! I bet the exam writer was feeling pretty clever with this one.

upvoted 0 times

Otis

9 months ago

Yep, the exam writer probably wanted to test our knowledge on this one.

upvoted 0 times

...

Jaime

10 months ago

Definitely, it's important for database consistency.

upvoted 0 times

...

Ben

10 months ago

I agree, it's like the boss of keeping things in order.

upvoted 0 times

...

Cecily

10 months ago

Entity integrity is key for maintaining uniqueness in the table.

upvoted 0 times

...

Jackie

10 months ago

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

upvoted 0 times

...

Maurine

10 months ago

I think the answer is A) Entity integrity.

upvoted 0 times

...