WGU Updated Data-Management-Foundations Exam Questions and Answers by antonina

Arelationshipin an ER model defineshow two separate entities interact.

Example Usage:

A screenshot of a computer AI-generated content may be incorrect.

CREATE TABLE Customers (

CustomerID INT PRIMARY KEY,

Name VARCHAR(50)

);

CREATE TABLE Orders (

OrderID INT PRIMARY KEY,

CustomerID INT,

FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)

);

Customers and Orders are separate entities, related via CustomerID.

Why Other Options Are Incorrect:

Option A (Reflexive relationship) (Incorrect):Used forself-referencing entities, not two different entities.

Option B (Entity type) (Incorrect):Defines aclass of objects, but does not establish relationships.

Option D (Attribute) (Incorrect):Attributesdescribeentities but do not connect them.

Thus, the correct answer isRelationship, as it connectstwo separate entities.

Attributesin a databaserepresent the properties (names, values, or characteristics) of an entity.

Example Usage:

In aStudentstable, attributes might include:

StudentID (Primary Key), Name, Age, Major

Here,Name is an attributedescribing the entityStudent.

Why Other Options Are Incorrect:

Option A (Synonyms) (Incorrect):Synonyms in SQL allow different names for the same object but arenot attributes.

Option C (Repositories) (Incorrect):A repository stores data butdoes not define attributes.

Option D (Relationships) (Incorrect):Relationships defineconnections between entities, not their attributes.

Thus, the correct answer isNames, asattributes define entity properties.

TheHAVINGclause is used in SQL to filtergrouped resultsgenerated by the GROUP BY clause. Unlike WHERE, which filters individual rowsbeforegrouping, HAVING filtersafter aggregationhas been performed.

Example Usage:

sql

SELECT Department, AVG(Salary) AS AvgSalary

FROM Employees

GROUP BY Department

HAVING AVG(Salary) > 50000;

This query first groups employees by Department, calculates theaverage salary per department, and then filters onlythose departments where the average salary is greater than 50,000.

Why Other Options Are Incorrect:

Option A (REPLACE) (Incorrect):Used for string substitution, not filtering.

Option C (WITH) (Incorrect):Used inCommon Table Expressions (CTEs), not for filtering.

Option D (WHERE) (Incorrect):Used forrow-level filtering before aggregation, but itcannot be used on aggregate functions like SUM() or AVG().

Thus,HAVING is the correct answerfor filtering after grouping.

In MySQL, theBIGINTdata type is a64-bit integerthat requires8 bytes (64 bits) of storage. It is used to store large numerical values beyond the range of INT (4 bytes).

Option A (Incorrect):1 byte corresponds toTINYINT, which can store values from -128 to 127.

Option B (Incorrect):3 bytes is not a standard integer storage size in MySQL.

Option C (Incorrect):4 bytes corresponds toINT, which has a range of -2,147,483,648 to 2,147,483,647.

Option D (Correct):BIGINT takes8 bytesand supports a massive range of numbers from -2^63 to 2^63 -1.