Data Integrity | MCQs

Explanation

The functional dependency is a relationship that exists between two attributes.

It typically exists between the primary key and non-key attribute within a table.

Explanation

Concurrency control manages simultaneous access to data in a database to prevent conflicts or data inconsistency.

It ensures data integrity when multiple users perform read/write operations at the same time.

Explanation

In asynchronous transmission, data is sent one byte at a time with start and stop bits, and often a parity bit for error checking.

It's commonly used in serial communication, like keyboards and older modems.

Explanation

Error Control in the data link layer is a process of detecting and retransmitting the data which has been lost or corrupted during the transmission of data. 

Explanation

A foreign key is used to link two tables and can contain duplicate values.

In contrast, primary, candidate, and even secondary keys are typically unique.

Explanation

Checksum: calculated value that is used to test data for the presence of errors 

Explanation

In database design, a composite key is a candidate key that consists of two or more attributes (table columns) that together uniquely identify an entity occurrence (table row).

A compound key is a composite key for which each attribute that makes up the key is a simple (foreign) key in its own right.