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