Data-Management-Foundations Exam Dumps : WGU Data Management – Foundations Exam

Aprimary keyuniquely identifies each row in a table. When a primary key consists ofonly one field, it is called aSimple Primary Key.

Types of Primary Keys:

Simple Primary Key (Correct Answer):

Contains onlyone column.

Example:

sql

CREATE TABLE Students (

StudentID INT PRIMARY KEY,

Name VARCHAR(50)

);

Composite Primary Key:

Usesmultiple columnsto ensure uniqueness.

Example:

sql

CREATE TABLE Orders (

OrderID INT,

ProductID INT,

PRIMARY KEY (OrderID, ProductID)

);

Surrogate Primary Key:

A system-generatedunique identifier(e.g., UUID or AUTO_INCREMENT).

Why Other Options Are Incorrect:

Option B (Duplicate) (Incorrect):A primary keymust be unique, so itcannot be duplicate.

Option C (Numeric) (Incorrect):While primary keyscan be numeric, they can also be alphanumeric (VARCHAR).

Option D (Composite) (Incorrect):Acompositekey consists ofmultiple fields, whereas a simple key isa single field.

Thus, the correct answer isSimple, since aone-field primary keyis a simple primary key.

Toadd a primary key constraint after table creation, we use theALTER TABLEstatement.

Example Usage:

sql

ALTER TABLE Employees

ADD CONSTRAINT PK_Employees PRIMARY KEY (EmpID);

Thisaddsa primary key to the EmpID columnafter the table was created.

Why Other Options Are Incorrect:

Option B (CREATE TABLE) (Incorrect):Used for defining constraintsduringtable creation, not after.

Option C (UPDATE) (Incorrect):Modifiesrow values, not constraints.

Option D (INSERT INTO) (Incorrect):Used toadd datato a table, not modify constraints.

Thus, the correct answer isALTER TABLE, as itmodifies table structure to add a primary key constraint.

TheALTER TABLEstatement is used to modify an existing database table structure. One common clause isCHANGE, which allows renaming a column and modifying its data type.

Example:

sql

ALTER TABLE Employees CHANGE COLUMN OldName NewName VARCHAR(50);

Option A (Incorrect):DELETE is used to removerows, not alter table structure.

Option B (Correct):CHANGE is avalid clausefor renaming and modifying columns in MySQL and some other databases.

Option C (Incorrect):STOP is not a valid SQL keyword for altering tables.

Option D (Incorrect):AGGREGATE refers to functions like SUM() and AVG(), not table alterations.