Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 40 of 79

Table Creation and Data Manipulation Commands — Question 14

Back to all questions
14
Question

Question 14

Which of the following is not a legal constraint for a CREATE TABLE command ?

  1. Primary key
  2. Foreign key
  3. Unique
  4. Distinct
Answer

Distinct

Reason — The legal constraints for a CREATE TABLE command include the Primary key constraint, Foreign key constraint, Unique constraint, Check constraint, Default constraint. However, the Distinct is not a valid option for a CREATE TABLE command.