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.