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...