pg. 1
WGU C175 NEWEST 2024 –2025 COMPLETE
REAL EXAM QUESTIONS WITH DETAILED
(VERIFIED) ANSWERS/ RATED A+
In what two ways does a DBMS environment increase effectiveness in working with data? - Correct Answer - - Enables Data Sharing
- Storage of vast volumes of data
A company posts an internet-based newsletter about their products. What advantage will this company gain from the relational database management system that will store customer information? - Correct Answer - Improved query response time
What is the method of organizing attributes into tables? - Correct Answer - Data
NORMALIZATION
What should a company expect from implementing a business intelligence system? -
Correct Answer - - Financial: Increased profitability
- Productivity: Increased throughput, decreased workloads
- Trust: greater satisfaction
- Risk: improved visibility
What is a relational model? - Correct Answer - A database model based on mathematical principles
What are the 3 mathematical concepts of the relational model? - Correct Answer –
- Domain
- Tuple - Relation 1 / 3
pg. 2
What does modality refer to? How does it appear on ER diagram? - Correct Answer - Refers to the MINIMUM number of times an instance in one entity can be associated with instance of another entity (minima) Appears as a 0 or 1 on the relationship line, next to cardinality
Define: Referential Integrity - Correct Answer - Requires that ALL foreign key values must either be fully NULL or match some primary key value
4 Ways Referential Integrity can be violated: - Correct Answer –
- Primary key is updated
- Foreign key is updated
- Row containing primary key is DELETED
- Row containing foreign key is INSERTED
4 Actions to Correct Referential Integrity Violation: - Correct Answer –
- RESTRICT - rejects an insert, update, or delete
- SET NULL - sets invalid foreign keys to null
- SET DEFAULT - sets invalid foreign keys to a default primary value
- CASCADE - propagates primary key changes to foreign keys
What is an important aspect to referential integrity? - Correct Answer - reference to data in one relation is based on values in another relation
What is a broad definition of data? - Correct Answer - Raw facts captured on printed or digital media
What are data? - Correct Answer - Facts that are collected and stored in a database system
- / 3
pg. 3 What is a determining characteristic of unstructured data? - Correct Answer - It does not follow a data model
What is true about flat files? - Correct Answer - - They contain no internal hierarchical organization
How were data retrieved before database management systems? - Correct Answer - Sequentially from simple files
What is an attribute or group of attributes that uniquely identify a tuple in a relation? - Correct Answer - Primary Key
What is necessary for a primary key in one relation of a database to match with its corresponding foreign key in another relation of the same database? - Correct Answer - A domain of values
What uniquely identifies each entity in a collection of entities but is not the primary key?
- Correct Answer - Alternate Key
What is the term for a set of columns in a table that can uniquely identify any record in that table without referring to other data? - Correct Answer - Candidate Key
What happens to the original data in database indexing? - Correct Answer - It is copied to the index
Why are indexes created in a physical database design? - Correct Answer - To retrieve data DIRECTLY using a pointer
Why is an index created on a database column? - Correct Answer - To optimize data retrievals
- / 3