COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Choose multiple correct answers: To create a database, the DBMS allows users to
|
|
Declare the data type
|
|
|
Declare data structure
|
|
|
Declare constraints on data
|
|
|
Organize and control concurrent accesses
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -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-3: -Constraints available in SQL are: NOT NULL. UNIQUE. PRIMARY KEY. FOREIGN KEY.
There is 1 question to complete.