Select the commands for creating a new table or editing table named STUDENT which would contain the following info: ID (key field), student’s first and last names (select all correct answers).

Question

Accepted Answer

ALTER TABLE STUDENT ADD CONSTRAINT ID PRIMARY KEY(ID);

Accepted Answer

ALTER TABLE STUDENT ALTER COLUMN ID INT NOT NULL;

Accepted Answer

CREATE TABLE STUDENT(ID INT PRIMARY KEY, FIRSTNAME VARCHAR(30), LASTNAME VARCHAR(30))

Answer

ALTER TABLE STUDENT ADD CONSTRAINT ID PRIMARY KEY(ID)

Answer

CREATE TABLE STUDENT(ID INT, FIRSTNAME VARCHAR(30), LASTNAME VARCHAR(30));

Answer

CREATE TABLE STUDENT(ID INT, FIRSTNAME VARCHAR(30), LASTNAME VARCHAR(30))

Answer

CREATE TABLE STUDENT(ID INT ALTER ID PRIMARY KEY, FIRSTNAME VARCHAR(30), LASTNAME VARCHAR(30))

Answer

ALTER TABLE STUDENT ALTER COLUMN ID INT NOT NULL ADD CONSTRAINT ID PRIMARY KEY(ID)

Crowdly

Select the commands for creating a new table or editing table named STUDENT whic...

Want instant access to all verified answers on softserve.academy?