DATA MANAGEMENT FOUNDATIONS WGU C175 D426 OA EXAM 3 ACTUAL EXAM LATEST WITH 2 LATEST UPDATED VERSIONS COMPLETE 300 REAL QUESTIONS AND WELL ELABORATED ANSWERS (100 CORRECT VERIFIED ANSWERS)

WGU C175/D426 DATA MANAGEMENT g g g g




FOUNDATIONS OAEXAM 2023- g g




2024 ACTUAL EXAM 2 LATEST VERSIO gg g g g g




NS 300QUESTIONS AND CORRECT AN
gg g g gg




SWERS (100% VERIFIED ANSWERS) g g gg g




VERSION A g




What does modality refer to? How does it appear on ER diagram? - ANSWER-
g g g g g g g g g g g g g


Refers to the MINIMUM number of times an instance in one entity can be associate
g g g g g g g g g g g g g g g


d with instance of another entity (minima)
g g g g g g


Appears as a 0 or 1 on the relationship line, next to cardinality
g g g g g g g g g g g g




Define: Referential Integrity - ANSWER-
g g g g


Requires that ALL foreign key values must either be fully NULL or match some pri
g g g g g g g g g g g g g g g


mary key value
g g




4 Ways Referential Integrity can be violated: - ANSWER- 1. Primary key is updated
g g g g g g g g g g g g g


2. Foreign key is updated g g g


3. Row containing primary key is DELETED
g g g g g


4. Row containing foreign key is INSERTED
g g g g g




4 Actions to Correct Referential Integrity Violation: - ANSWER- 1. RESTRICT -
g g g g g g g g g g g


rejects an insert, update, or delete
g g g g g g


2. SET NULL - sets invalid foreign keys to null
g g g g g g g g


3. SET DEFAULT - sets invalid foreign keys to a default primary value
g g g g g g g g g g g


4. CASCADE - propagates primary key changes to foreign keys g g g g g g g g




What is an important aspect to referential integrity? - ANSWER-
g g g g g g g g g


reference to data in one relation is based on values in another relation
g g g g g g g g g g g g g




Stuvia.comg-gThegMarketplacegtogBuygandgSellgyourgStudygMaterial

,What is a broad definition of data? - ANSWER-
g g g g g g g g


Raw facts captured on printed or digital media
g g g g g g g g




What are data? - ANSWER- Facts that are collected and stored in a database system
g g g g g g g g g g g g g g




What is a determining characteristic of unstructured data? - ANSWER-
g g g g g g g g g


It does not follow a data model
g g g g g g g




What is true about flat files? - ANSWER- -
g g g g g g g g


They contain no internal hierarchical organization
g g g g g g




How were data retrieved before database management systems? - ANSWER-
g g g g g g g g g


Sequentially from simple files
g g g g




What is an attribute or group of attributes that uniquely identify a tuple in a relation?
g g g g g g g g g g g g g g g g


- ANSWER- Primary Key
g g g




What is necessary for a primary key in one relation of a database to match with its cor
g g g g g g g g g g g g g g g g g


responding foreign key in another relation of the same database? - ANSWER-
g g g g g g g g g g g


A domain of values
g g g g




What uniquely identifies each entity in a collection of entities but is not the primary
g g g g g g g g g g g g g g g


key? - ANSWER- Alternate Key
g g g g




What is the term for a set of columns in a table that can uniquely identify any record
g g g g g g g g g g g g g g g g g g


in that table without referring to other data? - ANSWER- Candidate Key
g g g g g g g g g g g




What happens to the original data in database indexing? - ANSWER-
g g g g g g g g g g


It is copied to the index
g g g g g g




Why are indexes created in a physical database design? - ANSWER-
g g g g g g g g g g


To retrieve data DIRECTLY using a pointer
g g g g g g g




Why is an index created on a database column? - ANSWER-
g g g g g g g g g g


To optimize data retrievals
g g g g




Define: Functional Dependency - ANSWER-
g g g g


Each value of a column relates to at MOST one value of another column
g g g g g g g g g g g g g g

,Dependence of one column on another
g g g g g

, What term is used to describe: a value of one particular attribute associated with a sp
g g g g g g g g g g g g g g g


ecific single value of another attribute? - ANSWER- Functional Dependency
g g g g g g g g g




Rules/Appearance of First Normal Form - ANSWER- - All non- g g g g g g g g g


key columns depend on primary key
g g g g g


- Each table cell contains one value
g g g g g


- A table with no duplicate rows
g g g g g




Rules/Appearance of Second Normal Form - ANSWER- - When all non- g g g g g g g g g g


key columns depend on the WHOLE primary key
g g g g g g g


- Must be in 1NF g g g


- Non-key column can not depend on just one part of a composite key - a single
g g g g g g g g g g g g g g g


gprimary key is automatically in 2NFg g g g g




Rules/Appearance of Third Normal Form - ANSWER- - All non- g g g g g g g g g


key columns depend ONLY on the primary key
g g g g g g g


- Tables are totally free of data redundancy
g g g g g g




What are the 4 ways that operational and analytical databases differ? - ANSWER-
g g g g g g g g g g g g


- Volat ility g


- Detail
- Scope
- History

Define: Volatility; How it applies to Operational? Analytical? - ANSWER- -
g g g g g g g g g g


Database updates in real time g g g g


- Operational Data is Volatile
g g g g


- Analytical Data is NOT Volatile g g g g




Define: Detail; How it applies to operational and analytical DB? - ANSWER- -
g g g g g g g g g g g g


A database that keeps record of individual transactions; line items
g g g g g g g g g g


- Operational: Detailed g


- Analytical: Detailed
g g




Define: Scope; How it applies to operational and analytical DB? - ANSWER- -
g g g g g g g g g g g g g



How far a database can reach
g g g g g


Operational: incompatible g


Analytical:

Stuvia.comg-gThegMarketplacegtogBuygandgSellgyourgStudygMaterial