Western Governors University
Bachelor of Science — Information Technology
C170 · Data Management Applications · OA 300
WGU C170
DATA MANAGEMENT
APPLICATIONS
OA 300 — Objective Assessment
Comprehensive Study Guide & Practice Q&A
186 Questions & Answers | 10 Topic Sections
,WGU C170 Data Management Applications — OA 300 Study Guide
Table of Contents
Section 1. Database Fundamentals & Concepts (11 questions)
Section 2. Keys, Relationships & Data Types (18 questions)
Section 3. Database Design: Analysis & ER Modeling (17 questions)
Section 4. Relationships: Rules & Integrity (12 questions)
Section 5. DBMS Architecture (6 questions)
Section 6. Normalization & Normal Forms (29 questions)
Section 7. SQL Language & Sublanguages (43 questions)
Section 8. Relational Algebra & Advanced Queries (28 questions)
Section 9. ER Modeling: Cardinality & Subtypes (29 questions)
Section 10. MySQL Architecture & Physical Design (0 questions)
WGU C170 Data Management Applications — OA 300 Study Guide Page 2 of 43
,WGU C170 Data Management Applications — OA 300 Study Guide
SECTION 1
Database Fundamentals & Concepts
Q.1 ANSWER
When you move data from an unstructured form Answer: D) All of the above
to a structured form, what benefit do you gain?
All of the above — structuring data gives you the ability to
A) The ability to use data programmatically use it programmatically, locate it easily, and sort it.
B) The ability to easily locate data
C) The ability to easily sort data
D) All of the above
Q.2 ANSWER
When you store data in a database, what is one Answer: A) Rows of data can be associated with
advantage you get over a plain spreadsheet? each other across tables
A) Rows of data can be associated with each other across The ability to create relationships between tables is a core
tables function of relational databases.
B) You can keep information stored in a regular, organized
way
C) You can insert and delete data
D) Data can be sorted by column
Q.3 ANSWER
What is one advantage of using a spreadsheet to Answer: D) It can help you see gaps in the data
store data?
When pieces of information are arranged in a consistent
A) It protects data from becoming inconsistent way, it becomes easier to see what information you have
B) It ensures that the data is correct and what is missing.
C) It protects data from unauthorized changes
D) It can help you see gaps in the data
Q.4 ANSWER
The definition of how data in a database will be Answer: B) Schema
organized is called the ________?
The database schema includes information about the
A) Setting layout of tables and other metadata about the database
B) Schema itself.
C) Tables
D) Layout
Q.5 ANSWER
What is a DBMS? Open Answer — See Explanation
Database Management System — software used to
interact with and create, process, and administer
databases (e.g., Microsoft Access, SQL Server, MySQL).
WGU C170 Data Management Applications — OA 300 Study Guide Page 3 of 43
, WGU C170 Data Management Applications — OA 300 Study Guide
Q.6 ANSWER
What is structured data? Open Answer — See Explanation
Data stored in a traditional system such as a relational
database or spreadsheet, organized into tables with rows
and columns.
Q.7 ANSWER
What is a transaction? Open Answer — See Explanation
A group of queries that must either all be completed
successfully or are rejected as a whole.
Q.8 ANSWER
What is CRUD? Open Answer — See Explanation
The four common database operations: Create, Read,
Update, Delete.
Q.9 ANSWER
A unique value ________. Answer: C) Occurs only once in a given column
A) Almost never repeats Unique values are useful because they never appear twice
B) Occurs only once in a given table in a given column. If a value appears more than once in a
C) Occurs only once in a given column column, it is not unique in that column.
D) Occurs only once in a given row
Q.10 ANSWER
A relationship connects two pieces of data in Answer: D) Tables; databases
different _____ in the same _______.
Even though a relationship is concerned with individual
A) Rows; databases rows, it is defined as being between tables in the same
B) Columns; table database.
C) Fields; row
D) Tables; databases
Q.11 ANSWER
What are four benefits to utilizing databases? Open Answer — See Explanation
1) They provide structure to the data; 2) They allow
enforcement rules to be applied; 3) They protect data from
unauthorized access or changes; 4) They ensure changes
only get made if all associated changes are made
successfully.
WGU C170 Data Management Applications — OA 300 Study Guide Page 4 of 43
Bachelor of Science — Information Technology
C170 · Data Management Applications · OA 300
WGU C170
DATA MANAGEMENT
APPLICATIONS
OA 300 — Objective Assessment
Comprehensive Study Guide & Practice Q&A
186 Questions & Answers | 10 Topic Sections
,WGU C170 Data Management Applications — OA 300 Study Guide
Table of Contents
Section 1. Database Fundamentals & Concepts (11 questions)
Section 2. Keys, Relationships & Data Types (18 questions)
Section 3. Database Design: Analysis & ER Modeling (17 questions)
Section 4. Relationships: Rules & Integrity (12 questions)
Section 5. DBMS Architecture (6 questions)
Section 6. Normalization & Normal Forms (29 questions)
Section 7. SQL Language & Sublanguages (43 questions)
Section 8. Relational Algebra & Advanced Queries (28 questions)
Section 9. ER Modeling: Cardinality & Subtypes (29 questions)
Section 10. MySQL Architecture & Physical Design (0 questions)
WGU C170 Data Management Applications — OA 300 Study Guide Page 2 of 43
,WGU C170 Data Management Applications — OA 300 Study Guide
SECTION 1
Database Fundamentals & Concepts
Q.1 ANSWER
When you move data from an unstructured form Answer: D) All of the above
to a structured form, what benefit do you gain?
All of the above — structuring data gives you the ability to
A) The ability to use data programmatically use it programmatically, locate it easily, and sort it.
B) The ability to easily locate data
C) The ability to easily sort data
D) All of the above
Q.2 ANSWER
When you store data in a database, what is one Answer: A) Rows of data can be associated with
advantage you get over a plain spreadsheet? each other across tables
A) Rows of data can be associated with each other across The ability to create relationships between tables is a core
tables function of relational databases.
B) You can keep information stored in a regular, organized
way
C) You can insert and delete data
D) Data can be sorted by column
Q.3 ANSWER
What is one advantage of using a spreadsheet to Answer: D) It can help you see gaps in the data
store data?
When pieces of information are arranged in a consistent
A) It protects data from becoming inconsistent way, it becomes easier to see what information you have
B) It ensures that the data is correct and what is missing.
C) It protects data from unauthorized changes
D) It can help you see gaps in the data
Q.4 ANSWER
The definition of how data in a database will be Answer: B) Schema
organized is called the ________?
The database schema includes information about the
A) Setting layout of tables and other metadata about the database
B) Schema itself.
C) Tables
D) Layout
Q.5 ANSWER
What is a DBMS? Open Answer — See Explanation
Database Management System — software used to
interact with and create, process, and administer
databases (e.g., Microsoft Access, SQL Server, MySQL).
WGU C170 Data Management Applications — OA 300 Study Guide Page 3 of 43
, WGU C170 Data Management Applications — OA 300 Study Guide
Q.6 ANSWER
What is structured data? Open Answer — See Explanation
Data stored in a traditional system such as a relational
database or spreadsheet, organized into tables with rows
and columns.
Q.7 ANSWER
What is a transaction? Open Answer — See Explanation
A group of queries that must either all be completed
successfully or are rejected as a whole.
Q.8 ANSWER
What is CRUD? Open Answer — See Explanation
The four common database operations: Create, Read,
Update, Delete.
Q.9 ANSWER
A unique value ________. Answer: C) Occurs only once in a given column
A) Almost never repeats Unique values are useful because they never appear twice
B) Occurs only once in a given table in a given column. If a value appears more than once in a
C) Occurs only once in a given column column, it is not unique in that column.
D) Occurs only once in a given row
Q.10 ANSWER
A relationship connects two pieces of data in Answer: D) Tables; databases
different _____ in the same _______.
Even though a relationship is concerned with individual
A) Rows; databases rows, it is defined as being between tables in the same
B) Columns; table database.
C) Fields; row
D) Tables; databases
Q.11 ANSWER
What are four benefits to utilizing databases? Open Answer — See Explanation
1) They provide structure to the data; 2) They allow
enforcement rules to be applied; 3) They protect data from
unauthorized access or changes; 4) They ensure changes
only get made if all associated changes are made
successfully.
WGU C170 Data Management Applications — OA 300 Study Guide Page 4 of 43
