WGU Data Management - Foundations Exam Questions

Answer : B

In SQL, a primary key is explicitly defined using the PRIMARY KEY keyword when creating a table.

Example Usage:

sql

CREATE TABLE Products (

ProductID INT PRIMARY KEY,

Name VARCHAR(100),

Price DECIMAL(10,2)

);

Here, PRIMARY KEY is the SQL keyword that designates ProductID as the primary key.

Why Other Options Are Incorrect:

Option A (Formula in SQL) (Incorrect): SQL does not use formulas to define primary keys.

Option C (Bold typeface) (Incorrect): SQL syntax does not rely on text formatting.

Option D (Diamond symbol) (Incorrect): ER diagrams might use symbols, but SQL does not use diamonds to indicate keys.

Thus, the correct answer is SQL keyword, as primary keys are explicitly defined using PRIMARY KEY.

Answer : A

A data type defines the kind of data a column can store in a database. It ensures data consistency and efficient storage.

Option A (Correct): A data type is a named set of values, such as INTEGER, VARCHAR, DATE, etc.

Option B (Incorrect): A tuple refers to a row in a relational database, not a data type.

Option C (Incorrect): Data types define column values, but they do not correspond directly to columns.

Option D (Incorrect): Data types do not have a varying set of rows; they define attributes for columns.

Answer : A

The LTRIM() function in SQL removes leading spaces (spaces at the beginning of a string) while keeping spaces at the end.

Example Usage:

sql

SELECT LTRIM(' Hello World') AS TrimmedText;

Output:

bash

'Hello World'

Why Other Options Are Incorrect:

Option B (LEFT) (Incorrect): Used for extracting a portion of a string. Example:

sql

SELECT LEFT('Hello World', 5); -- Output: 'Hello'

Option C (TRIM) (Incorrect): Removes both leading and trailing spaces, not just leading ones. Example:

sql

SELECT TRIM(' Hello World '); -- Output: 'Hello World'

Option D (REPLACE) (Incorrect): Replaces occurrences of one substring with another but does not specifically remove spaces.

Thus, the correct answer is LTRIM(), which removes only leading spaces.

Answer : C

A Transaction Manager ensures ACID (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 the query 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): The storage manager is responsible for translating queries into file system commands.

Answer : A

A primary key uniquely identifies each row in a table. When a primary key consists of only one field, it is called a Simple Primary Key.

Types of Primary Keys:

Simple Primary Key (Correct Answer):

Contains only one column.

Example:

sql

CREATE TABLE Students (

StudentID INT PRIMARY KEY,

Name VARCHAR(50)

);

Composite Primary Key:

Uses multiple columns to ensure uniqueness.

Example:

sql

CREATE TABLE Orders (

OrderID INT,

ProductID INT,

PRIMARY KEY (OrderID, ProductID)

);

Surrogate Primary Key:

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

Why Other Options Are Incorrect:

Option B (Duplicate) (Incorrect): A primary key must be unique, so it cannot be duplicate.

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

Option D (Composite) (Incorrect): A composite key consists of multiple fields, whereas a simple key is a single field.

Thus, the correct answer is Simple, since a one-field primary key is a simple primary key.

Answer : C

An alias is used in SQL to give a temporary name to a table or column within a query. It makes queries more readable and helps in cases where a table needs to be referenced multiple times (e.g., in a self-join).

Example Usage:

sql

SELECT e.Name, d.DepartmentName

FROM Employees AS e

JOIN Departments AS d

ON e.DeptID = d.ID;

Here, Employees is aliased as e and Departments as d, making the query shorter and clearer.

Why Other Options Are Incorrect:

Option A (HAVING) (Incorrect): Used to filter grouped results, not create aliases.

Option B (NEW) (Incorrect): Not a valid SQL keyword for aliasing.

Option D (UNION) (Incorrect): Combines result sets but does not rename tables.

Thus, the correct answer is ALIAS, which allows for temporary naming of tables or columns.

Answer : B

A Database Administrator (DBA) is responsible for the management, security, and performance of a database system. This includes controlling access to data, ensuring database integrity, optimizing performance, managing backups, and protecting the system from unauthorized access.

Option A (Incorrect): A DBA is not just a consumer of data but is primarily responsible for the database's management.

Option B (Correct): Security is one of the key responsibilities of a DBA, including enforcing user access controls and implementing encryption and authentication mechanisms.

Option C (Incorrect): While DBAs work with data structures, it is typically the role of a data architect or database designer to define data formats and schema structures.

Option D (Incorrect): Developing application programs that interact with the database is typically the role of software developers or database programmers, not DBAs.