WGU C170 Data Management – Applications
Latest Update 2024-2025 Actual Exam Questions
and 100% Verified Correct Answers Guaranteed
A+
1NF - CORRECT ANSWER: Normal form: No repeating groups, PK identified, all values
depend on PK
2NF - CORRECT ANSWER: Normal form: 1NF and no partial dependencies
3NF - CORRECT ANSWER: Normal form: 2NF and no transitive dependencies
4NF - CORRECT ANSWER: Normal form: 3NF and no independent multivalued
dependencies
access plan - CORRECT ANSWER: The result of parsing a SQL statement; it contains
the series of steps a DBMS will use to execute the query and return the result set in the
most efficient way
ALL - CORRECT ANSWER: This operator can be used to compare something to every
returned row of a subquery
ANY - CORRECT ANSWER: This operator can be used to compare something to a list
of values and return any rows that satisfy the criteria
automatic vs manual - CORRECT ANSWER: Whether query optimization is done by the
DBMS vs done by the programmer
B-tree index - CORRECT ANSWER: An ordered data structure organized as an upside-
down tree
, base table - CORRECT ANSWER: The table on which a view is based
batch update routine - CORRECT ANSWER: A routine that pools transactions into a
single group to update a master table in a single operation
BCNF (Boyce-Codd Normal Form) - CORRECT ANSWER: Normal form: every
determinant is a candidate key (special case of 3NF)
bitmap index - CORRECT ANSWER: An index that uses a bit array (0s and 1s) to
represent the existence of a value or condition
candidate key - CORRECT ANSWER: A minimal superkey; that is, a key that does not
contain a subset of attributes that is itself a superkey
cardinality - CORRECT ANSWER: Term for how many instances of one object are
related to instances of another object (maximum)
CHECK - CORRECT ANSWER: SQL command to validate data in an attribute, used
during table column creation
connectivity - CORRECT ANSWER: Term for the classification of the relationship
between entities. Classifications include 1:1, 1:M, and M:N
correlated subquery - CORRECT ANSWER: A subquery that executes once for each
row in the outer query
CREATE SCHEMA AUTHORIZATION - CORRECT ANSWER: SQL command to create
a database schema
CREATE TABLE AS - CORRECT ANSWER: SQL command to create a new table
based on a query in the user's database schema
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Tutordiligent. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $20.49. You're not tied to anything after your purchase.
