Is the following composite Primary key definition

Is the following composite Primary key definition correct:

CREATE TABLE Person (
   firstName  VARCHAR(20) PRIMARY KEY,
   lastName   VARCHAR(20) PRIMARY KEY
)

Explanation

Composite primary key is defined as follows:

CREATE TABLE Person (
   firstName  VARCHAR(20),
   lastName   VARCHAR(20),
   PRIMARY KEY(firstName, lastName)
)

Приєднуйся і вивчай SQL

або Дізнайся більше про Тести з SQL онлайн