WGU
Latest uploads at WGU. Looking for notes at WGU? We have lots of notes, study guides and study notes available for your school.
-
6350
- 0
-
300
All courses for WGU
- WGU 5317
- WGU C405 Anatomy and Physiology Task I 3
- WGU , 1
- WGU 1
- WGU C107, C405 Anatomy and Physiology I & II 1
- WGU C455 English Composition: Evaluate the benefits of pursuing a specific hobby C455 1
- WGU C493 Leadership and Professional Image C493 1
- WGU, 3
- WGU, , 1
- WGU: 1
Latest notes & summaries WGU
WGU C170 Chapter 2 Exam Review 
|Question and Answer| 100% Correct 
binary relationship *Ans* An ER term for an association (relationship) between two 
entities. For example, PROFESSOR teaches CLASS. 
cardinality *Ans* An attribute that can be further subdivided to yield additional 
attributes. For example, a phone number such as may be divided into an area 
code (615), an exchange number (898), and a four-digit code (2368). Compare to simple 
attribute. 
composite identifier *Ans* In ER m...
Data Management Foundations - WGU 
C175 Practice Questions |100% Correct| 
ad hoc query *Ans* A "spur-of-the-moment" question 
analytical database *Ans* A database focused primarily on storing historical data and 
business metrics used for tactical or strategic decision making 
availability *Ans* In the context of data security, it refers to the accessibility of data 
whenever required by authorized users and for authorized purposes 
centralized database *Ans* A database located at a single...
C170 - PRE-ASSESSMENT GUIDING 
QUESTIONS |100% CORRECT| #LATEST 
A salesperson is authorized to sell many products and a product can be sold by many 
salespersons. 
Which kind of binary relationship does this scenario describe? 
One-to-one 
One-to-many 
Many-to-many 
One-to-one binary *Ans* Many-to-many 
Which two examples are attributes? 
Choose 2 answers 
A person attending a meeting 
An employee number 
A sales meeting 
A meeting code *Ans* An employee number 
A meeting code 
Which ...
WGU C170 Chapter 5 Exam Review 
|Question and Answer| 100% Correct 
access plan *Ans* A set of instructions generated at application compilation time that is 
created and managed by a DBMS. The access plan predetermines how an application's 
query will access the database at run time. 
algorithms *Ans* A process or set of operations in a calculation. 
automatic query optimization *Ans* A method by which a DBMS finds the most 
efficient access path for the execution of a query. 
B-tree index...
C170 Final Exam |Question and Answer| 
100% Correct 
A salesperson is authorized to sell many products and a product can be sold by many 
salespersons. 
Which kind of binary relationship does this scenario describe? *Ans* Many-to-many 
Which two examples are attributes? *Ans* An employee number 
A meeting code 
Which delete rule sets column values in a child table to a missing value when the matching 
data is 
deleted from the parent table? *Ans* Set-to-Null 
member_id INT UNSIGNED NOT NULL AU...
Data Management Foundation C175 
WGU Exam Elaboration |Question and 
Answer| 2024/2025 
Associative Entity *Ans* An associative entity is an element of the entity-relationship 
model. All relationships for the associative entity should be many. 
Attribute *Ans* An attribute is a property or characteristic of an entity. 
Binary relationship *Ans* A binary relationship is a relationship between two entity 
types. 
Candidate Key *Ans* Is any column or a combination of columns that can qualify a...
WGU C170 Data Management – 
Applications 100% Correct Answers 
|Verified| Updated 
domain *Ans* In data modeling, the construct used to organize and describe an 
attribute's set of possible values 
superkey *Ans* An attribute or attributes that uniquely identify each entity in a table. 
Any composite key with this is also this. 
candidate key *Ans* A minimal superkey; that is, a key that does not contain a subset 
of attributes that is itself a superkey 
entity integrity *Ans* The propert...
FJ01 C170 Final Exam Tips |Updated| 
2024 
CREATE TABLE statements and data type assignments 
create table employee 
(first varchar(15), 
last varchar(20), 
age number(3), 
address varchar(30), 
city varchar(20), 
state varchar(20)); 
CREATE TABLE ... LIKE 
CREATE TABLE new_tbl_name LIKE tbl_name; 
CREATE TABLE ... SELECT 
Creates a new table from the result of an arbitrary SELECT statement 
- Does not include Auto Increment columns 
- Can specify which columns from an existing table 
CREATE TAB...
Explain the New, Evolutionary, and Pendulum views of Globalization. How do these 
differ from one another? - ANSWERS New globalization is a new force sweeping 
through the world in recent times. Pendulum globalization is a pendulum that swings 
from one extreme to the the other from time to time. Evolutionary globalization is a long 
historical evolution since the dawn of human history. 
What is Foreign Direct Investment? - ANSWERS Investment in controlling and 
managing value-added activit...
Suppose that the United States imposes a 
tariff on avocados imported from Mexico. 
What impact will this have on the price paid 
for avocados by United States citizens? - ANSWERS The price will increase. 
Which of the following is a consequence of a 
country imposing a tariff on imported goods? - ANSWERS The demand for foreign 
produced goods 
decreases. 
Suppose that the United States imposes a 
tariff on salt. What impact might this tariff 
have on the price for domestic consumers? - ANSWERS...