Solution:Step 1: Review correct ALTER TABLE syntaxAdding a composite primary key requires parentheses around columns separated by commas.Step 2: Identify correct syntaxALTER TABLE ProjectAssignments ADD PRIMARY KEY (project_id, employee_id); correctly uses parentheses and commas.Final Answer:ALTER T

[Solved] Given this table:CREATE TABLE ProjectAssignments ( project_id INT, employee_id INT, role VARCHAR(20), PRIMARY KEY (project_id, employee_id) );Which of the following ALTER TABLE statements correctly... | SQL

SQL - Table Constraints

Given this table:

CREATE TABLE ProjectAssignments (
  project_id INT,
  employee_id INT,
  role VARCHAR(20),
  PRIMARY KEY (project_id, employee_id)
);

Which of the following ALTER TABLE statements correctly adds a composite primary key on project_id and employee_id?

AALTER TABLE ProjectAssignments ADD PRIMARY KEY (project_id, employee_id);

BALTER TABLE ProjectAssignments ADD PRIMARY KEY project_id, employee_id;

CALTER TABLE ProjectAssignments ADD PRIMARY KEY (project_id AND employee_id);

DALTER TABLE ProjectAssignments ADD PRIMARY KEY project_id AND employee_id;

Step-by-Step Solution

Solution:

Step 1: Review correct ALTER TABLE syntax
Adding a composite primary key requires parentheses around columns separated by commas.
Step 2: Identify correct syntax
ALTER TABLE ProjectAssignments ADD PRIMARY KEY (project_id, employee_id); correctly uses parentheses and commas.
Final Answer:
ALTER TABLE ProjectAssignments ADD PRIMARY KEY (project_id, employee_id); -> Option A
Quick Check:
Use parentheses and commas in ALTER TABLE for composite keys [OK]

Quick Trick: Use parentheses and commas in ALTER TABLE for composite keys [OK]

Common Mistakes:

MISTAKES

Omitting parentheses
Using AND instead of commas
Listing columns without grouping

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given this table:

Step 1: Review correct ALTER TABLE syntax

Step 2: Identify correct syntax

Final Answer:

Quick Check:

Want More Practice?