CUET-UG SERIES Database-management-systems
Integrity Constraints
3 previous year questions.
Volume: 3 Ques
Yield: Medium
High-Yield Trend
3
2023 Chapter Questions 3 MCQs
01
PYQ 2023
medium
database-management-systems ID: cuet-ug-
Which two constraints when applied together will produce a primary key constraint?
1
Primary key, Default
2
Not NULL, Unique
3
Unique, Default
4
Primary key, Foreign key
02
PYQ 2023
medium
database-management-systems ID: cuet-ug-
Which two constraints when applied together will produce a primary key constraint ?
(A) NOT NULL
(B) UNIQUE
(C) DEFAULT
(D) ZERO
Choose the correct answer from the options given below:
(A) NOT NULL
(B) UNIQUE
(C) DEFAULT
(D) ZERO
Choose the correct answer from the options given below:
1
(B) only
2
(B) and (D) only
3
(A), (B) and (C) only
4
(A) and (B) only
03
PYQ 2023
medium
database-management-systems ID: cuet-ug-
Which statement is used to add a constraint in existing attribute of a relation?
1
UPDATE
2
SELECT
3
ALTER
4
CREATE