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.

Aunary relationship(also known as arecursive relationship) occurs when an entityrelates to itself.

Example Usage:

Employees and Managers:

sql

CREATE TABLE Employees (

EmpID INT PRIMARY KEY,

Name VARCHAR(50),

ManagerID INT,

FOREIGN KEY (ManagerID) REFERENCES Employees(EmpID)

);

Here, ManagerIDreferences another Employee→ aunary (self-referential) relationship.

Why Other Options Are Incorrect:

Option A (Modality) (Incorrect):Describesoptional vs. mandatoryrelationships, not self-referencing.

Option C (Cardinality) (Incorrect):Defines how many instances relate,not the type of relationship.

Option D (Binary) (Incorrect):Binary relationships involvetwo different entities, not self-referencing.

Thus, the correct answer isUnary, as it describesrelationships within the same entity type.

Thecorrect syntaxfor inserting a new row into a table follows this structure:

Standard SQL INSERT Syntax:

sql

INSERT INTO TableName (Column1, Column2, ...)

VALUES (Value1, Value2, ...);

For this scenario:

sql

INSERT INTO Employee (Name) VALUES ('John Doe');

Why Other Options Are Incorrect:

Option A (Incorrect):Uses incorrect syntax { ... }, which isnot valid SQL syntax.

Option C (Incorrect):Does not specify the column name, whichcauses an error.

Option D (Incorrect):Misses theINTOkeyword, which is required in standard SQL.

Thus, the correct syntax isOption B, ensuring aproperly formatted insert statement.

ATransaction ManagerensuresACID (Atomicity, Consistency, Isolation, Durability)properties in database transactions. It manages concurrent transactions, ensuring no conflicts occur and logs modifications to support recovery mechanisms.

Option A (Incorrect):Query optimization is managed by thequery processor, not the transaction manager.

Option B (Incorrect):The transaction manager is a component of the database architecture but is not composed of the entire system (query processor, storage manager, etc.).

Option C (Correct):The transaction manager logs transactions like INSERT, UPDATE, and DELETE, ensuring consistency and recoverability.

Option D (Incorrect):Thestorage manageris responsible for translating queries into filesystem commands.

MongoDB is aNoSQL (non-relational) databasethat isopen-sourceand supportsdocument-oriented storage. It allows for flexible schema design and is optimized for big data applications.

Option A (Correct):MongoDB is aNoSQL databasewith an open-sourceAGPLlicense, making it both free to use and non-relational.

Option B (Incorrect):SQL Serveris arelational database(RDBMS) developed by Microsoft and isnot open-source.

Option C (Incorrect):MySQLisopen-sourcebut is arelational database(RDBMS), not a NoSQL system.

Option D (Incorrect):Oracle Databaseisrelationalandproprietary(not open-source).