Integrity constraints ensure that change made to the database by authorized users do not result into loss of data consistency. Which of the following…
Integrity constraints ensure that change made to the database by authorized users do not result into loss of data consistency. Which of the following statement (s) is (are) true w.r.t. the examples of integrity constraints?
(A) An instructor Id. No. cannot be null, provided Instructor Id No. being primary key.
(B) No two citizens have same Adhar-Id
(C) Budget of a company must be zero
Show answerHide answer
Correct answer: (C) (A) and (B) are true; (C) false
Explanation
An instructor Id. No. cannot be null when it is the primary key – valid integrity constraint. No two citizens have the same Aadhaar-Id – valid. But 'the budget of a company must be zero' is not a valid integrity constraint. So (A) and (B) are true and (C) is false.