English

Which two constraints when applied together will produce a Primary Key constraint?

Advertisements
Advertisements

Question

Which two constraints when applied together will produce a Primary Key constraint?

Very Short Answer
Advertisements

Solution

The two constraints that together produce a Primary Key constraint are:

  1. NOT NULL – The attribute cannot contain a NULL value.
  2. UNIQUE – The attribute must contain unique values.

Therefore:

Primary Key = NOT NULL + UNIQUE

shaalaa.com
  Is there an error in this question or solution?
Chapter 8: Introduction to Structured Query Language (SQL) - Intext Questions [Page 146]

APPEARS IN

NCERT Informatics Practices [English] Class 11
Chapter 8 Introduction to Structured Query Language (SQL)
Intext Questions | Q 4. | Page 146
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×