Database Integrity

What does data integrity primarily ensure?

• Data speed

• Data accuracy and consistency

• Data size

• Data complexity

Which type of integrity ensures that if two tuples have the same values for the left side attribute, they must have the same values for the right side attributes?

• Domain integrity

• Entity integrity

• Functional dependency integrity

• Referential integrity

What is a domain in the context of database integrity?

• A set of tables

• A set of relationships

• A set of possible values for an attribute

• A set of constraints

Which of the following is an example of domain integrity?

• Ensuring a primary key is unique

• Preventing an integer variable from being set to “cat”

• Ensuring a foreign key references an existing primary key

• Defining a cascade delete

What SQL clause is used to create custom domain types?

• CREATE TABLE

• CREATE DOMAIN

• CREATE ATTRIBUTE

• CREATE INTEGRITY

Which integrity constraint states that no component of the primary key can accept NULL values?

• Referential integrity

• Domain integrity

• Entity integrity

• Functional dependency integrity

What is a primary key?

• A key that references another table

• A key that must contain NULL values

• A key that uniquely identifies each row in a table

• A key that defines attribute domains

Which type of integrity ensures that a value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation?

• Entity integrity

• Domain integrity

• Referential integrity

• Functional dependency integrity

What is a foreign key?

• A key that uniquely identifies a row in its own table

• A key that refers to a primary key in another table

• A key that cannot contain NULL values

• A key that defines attribute domains

What happens if referential integrity is violated during a database operation by default?

• The operation is cascaded

• The operation is rejected

• The operation is ignored

• The operation updates the related table