COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
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: -The following constraints are commonly used in SQL: NOT NULL-Ensures that a column cannot have a NULL value. UNIQUE-Ensures that all values in a column are different. PRIMARY KEY-A combination of a NOT NULL and UNIQUE .
Detailed explanation-2: -Constraints in DBMS are the restrictions that are applied to data or operations on the data. This means that constraints allow only a particular kind of data to be inserted in the database or only some particular kind of operations to be performed on the data in the database.
Detailed explanation-3: -NOT NULL Constraint. UNIQUE Constraint. DEFAULT Constraint. CHECK Constraint. PRIMARY KEY Constraint. FOREIGN KEY Constraint.
There is 1 question to complete.