Question:

Which two constraints when applied together will produce a primary key constraint?

Updated On: Apr 19, 2024

Primary key, Default
Not NULL, Unique
Unique, Default
Primary key, Foreign key

Hide Solution

Verified By Collegedunia

The Correct Option is B

Solution and Explanation

The correct option is(B): NOT NULL, UNIQUE

Was this answer helpful?

0

0

Top Questions on Integrity constraints

Match LIST I with LIST II
LIST I

LIST II
A Constraint I Clause
B DDL II Operator
C Where III Alter table
D Like IV Default
Choose the correct answer from the options given below
- CUET (UG) - 2023
- Computer Science
- Integrity constraints
View Solution
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:
- CUET (UG) - 2023
- Database Management Systems
- Integrity constraints
View Solution
Which statement is used to add a constraint in existing attribute of a relation?
- CUET (UG) - 2023
- Database Management Systems
- Integrity constraints
View Solution

Questions Asked in CUET exam

The corner points of the feasible region determined by $x + y \leq 8$, $2x + y \geq 8$, $x \geq 0$, $y \geq 0$ are $A(0, 8)$, $B(4, 0)$, and $C(8, 0)$. If the objective function $Z = ax + by$ has its maximum value on the line segment $AB$, then the relation between $a$ and $b$ is:
- CUET (UG) - 2024
- Linear Programmig Problem
View Solution

Match the words in List-I with their definitions in List-II :

List-I (Words)	List-II (Definitions)
(A) Theocracy	(I) One who keeps drugs for sale and puts up prescriptions
(B) Megalomania	(II) One who collects and studies objects or artistic works from the distant past
(C) Apothecary	(III) A government by divine guidance or religious leaders
(D) Antiquarian	(IV) A morbid delusion of one’s power, importance or godliness

Choose the correct answer from the options given below :

CUET (UG) - 2024
Vocabulary

View More Questions