A table Account is defined as: CREATE TABLE Account ( AccNo INT PRIMARY KEY,…

BEL Probationary Engineer 2025

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. A.

    Updating balance to 200

  2. B.

    Deleting an existing record

  3. C.

    Inserting a NULL value into AccNo

  4. D.

    Inserting a duplicate AccNo value

Attempted by 122 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…