Constraints which deal with changes in database are classified as

When database is created there are many constraints which go along like Table constraints, Column constraints classified under row level and table level constraints.

Constraints are used to control what data is stored in table. This ensures the ATOM properties of the data in the database.

Now there may be scenarios where we need to change the constraints after the database is created. These are called Transition Constraints.

in MCQ questions you may get options like

a.assertion constraints
b.trigger constraints
c.specified constraints
d.transition constraints

Ans is D- transition constraints

So finally the answer for questions

The constraints which deal with changes in database are classified as what?

Transition Constraints : because it deals in transition of the restrictions on a database.

What is the use of Database constraints?

To control what data is stored inside the tables to maintain data integrity.

more about computing

See also  Based on the values in cell b77:b81 what functions can automatically return the value in cell c77

Leave a Comment