DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
constraint
|
|
|
key
|
|
|
association
|
|
|
qualifier
|
Detailed explanation-1: -In DBMS, constraints are the set of rules that ensures that when an authorized user modifies the database they do not disturb the data consistency and the constraints are specified within the DDL commands like “alter” and “create” command.
Detailed explanation-2: -Constraints are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the table. If there is any violation between the constraint and the data action, the action is aborted. Constraints can be column level or table level.
Detailed explanation-3: -Data Integrity is used to maintain the accuracy and consistency of data in a table.
Detailed explanation-4: -Integrity constraints in DBMS are used to ensure that data is consistent and accurate. There are four main types of integrity constraints: domain, entity, referential, and key.