Question 119Asked in BEL PE Computer Science, 20 Dec 2025 (5:00 PM)

A table Account is defined as: CREATE TABLE Account (

A table Account is defined as: CREATE TABLE Account ( AccNo INT PRIMARY KEY, Balance DECIMAL(10,2) CHECK (Balance >= 500) ); Which sequence of operations violates data integrity without violating entity integrity?
  1. ADeleting an existing record
  2. BUpdating balance to 200
  3. CInserting a NULL value into AccNo
  4. DInserting a duplicate AccNo value
Show answerHide answer

Correct answer: (B) Updating balance to 200

From BEL PE Computer Science PYQ, 20 Dec 2025 (5:00 PM)

This is question 119 of BEL PE Computer Science PYQ, 20 Dec 2025 (5:00 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.