Relational Database Constraints

What are Integrity Constraints?

• Set of attributes that represent the property of an object

• Set of rules that are used to maintain the information's quality

• Set of rules that store all back up data

• Set of rules thar are used to protect unauthorized access to the data

Which of the following best describes the impact of a NULL constraint on data integrity?

• It ensures that a column must have a unique value

• It allows any value, including NULL, to be stored in the column

• It prevents NULL values, ensuring that each row has a valid entry for the column

• It automatically increments the value of the column

Which of the following statements best describes the use of a Foreign Key?

• They indicate the column (or combination of columns) that uniquely identify each row

• They reference, or link to, the primary key of another table, and are used to maintain the relationships between tables

• They are used to identify whether a user has write-access to a specific table

• They indicate the column where data has been ingested from a different table

How is data in a relational table organized?

• Row and Columns

• Header and Footer

• Pages and Paragraph

• Header and Pages

What is a derived attribute in a database?

• An attribute that uniquely identifies a record in a table

• An attribute that can take multiple values

• An attribute whose value is calculated from other attributes

• An attribute that is used to establish a relationship between two tables

Who is your database technology lecturer?

• Said Ahmad

• Sahid Achmad

• Said Achmad

• Sahid Ahmad