SQL PRIMARY KEY fo Server, Oracle, MS Access

CREATE TABLE Guests (
    ID int NOT NULL,
    Surname varchar(100) NOT NULL,
    Name varchar(100),
    Age int,
    CONSTRAINT PK_Guest PRIMARY KEY (ID,Surname)
);