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

In SQL, a composite primary key (primary key spanning multiple columns) must be declared using table-level constraint syntax. Column-level constraints apply to single columns only. NOT NULL (B), UNIQUE (C), and CHECK (D) can all be declared at column level. Only composite primary keys require the table CONSTRAINT syntax like CONSTRAINT pk_name PRIMARY KEY (col1, col2).

Keep practicing — related questions