AMU 2026 — Computer PYQ
AMU | Computer | 2026The employee salary should not be greater than Rs.15000, this is
Choose the correct answer:
- A.
integrity constraint
(Correct Answer) - B.
referential constraint
- C.
over defined constraint
- D.
feasible constraint
integrity constraint
Explanation
What is an Integrity Constraint? Integrity constraints are a set of rules used to maintain the quality, accuracy, and reliability of data in a database. They ensure that any data insertion, update, or deletion does not violate data consistency.
Why is this specific example an Integrity Constraint? Limiting an employee's salary to not exceed Rs.15000 is a specific type of integrity constraint known as a Domain Integrity Constraint (or more specifically, a Check Constraint). It restricts the allowable range of values for a particular attribute (column).
Explanation
What is an Integrity Constraint? Integrity constraints are a set of rules used to maintain the quality, accuracy, and reliability of data in a database. They ensure that any data insertion, update, or deletion does not violate data consistency.
Why is this specific example an Integrity Constraint? Limiting an employee's salary to not exceed Rs.15000 is a specific type of integrity constraint known as a Domain Integrity Constraint (or more specifically, a Check Constraint). It restricts the allowable range of values for a particular attribute (column).