Skip to content
Related Articles

Related Articles

UGC-NET | UGC NET CS 2017 Jan – II | Question 17
  • Last Updated : 26 Mar, 2018

Integrity constraints ensure that changes 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 Intructor Id No. being primary key.
(B) No two citizens have same Adhar-Id.
(C) Budget of a company must be zero.
(A) (A), (B) and (C) are true.
(B) (A) false, (B) and (C) are true.
(C) (A) and (B) are true; (C) false.
(D) (A), (B) and (C) are false


Answer: (C)

Explanation: (A) An instructor Id. No. cannot be null, provided Instructor Id No. being primary key. Correct by Codd’s rule
(B) No two citizens have same Adhar-Id. Correct because Adhar is identification for citizens so it must be unique
(C) Budget of a company must be zero. We cant say or it is not necessarily true
So, option (C) is correct.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :