Multiple choice technology databases

You can declare this only by using table contraint syntax

  1. Composite primarykey

  2. Not null

  3. unique

  4. check
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A composite primary key involves multiple columns and must be declared using table-level constraint syntax (outside the column definitions). Single-column constraints like NOT NULL, UNIQUE, and CHECK can be declared inline with the column. For example: CREATE TABLE foo (a INT, b INT, PRIMARY KEY (a,b)) - the PRIMARY KEY clause at table level creates a composite key. Inline column syntax cannot specify multiple columns for a single constraint.

Keep practicing — related questions