WGU C724 Information Systems Management
Unit 4 Test questions and answers 2026\2027
A+ Grade
What are tuples and how are they used in databases?
a.) A tuple is a collection of sequenced data fields
b.) A tuple is one record or data set in a row
c.) A tuple is a database field -
correct answer A tuple is one record or data set in a row
What is the best description of a flat file database?
a.) Flat file databases are hierarchical in nature.
b.) Flat file databases are prevalent today because they provide relational functions.
c.) The flat file design is a single table database. -
correct answer The flat file design is a single table database
WHAT means that the data is accurate and consistent through its use and application time?
a.) Data integrity
b.) Normalization
,c.) Fidelity -
correct answer Data integrity
A database schema can be represented by which model?
a.) ERD (Entity-relationship Diagram)
b.) Data Repository
c.) Foreign Keys -
correct answer ERD
During the database design process, WHAT takes place to eliminate data redundancy?
a.) Normalization
b.) Integrity review
c.) Redundancy elimination -
correct answer Normalization
Why did relational database models replace hierarchical database models in business applications?
a.) Relational databases don't use SQL, which is used in hierarchical databases.
b.) Relational databases have simpler table relationships than hierarchical databases.
c.) Relational databases are less expensive than hierarchical databases. -
correct answer Relational databases have simpler table relationships than hierarchical databases
Big Data database size is considered to be in WHAT size level?
a.) Petabyte
b.) Megabyte
, c.) Terabyte -
correct answer Petabyte
Why are data warehouses beneficial to business managers?
a.) Data warehouses store operational data.
b.) Data warehouses increase the effectiveness of OLTP databases.
c.) Data warehouses can be mined or analyzed for trends or patterns. -
correct answer Data warehouses can be mined or analyzed for trends or patterns
What is the best definition of data integrity?
a.) Data integrity means data is current.
b.) Data integrity is a process to ensure data is not corrupted.
c.) Data integrity means data is secure and reproducible. -
correct answer Data integrity is a process to ensure data is not corrupted
It is good practice to do WHAT to data that is backed up on a regular basis?
a.) Reduce
b.) Copy
c.) Duplicate -
correct answer Reduce
Why is it not good practice to perform analytics on an online transaction processing database?
Unit 4 Test questions and answers 2026\2027
A+ Grade
What are tuples and how are they used in databases?
a.) A tuple is a collection of sequenced data fields
b.) A tuple is one record or data set in a row
c.) A tuple is a database field -
correct answer A tuple is one record or data set in a row
What is the best description of a flat file database?
a.) Flat file databases are hierarchical in nature.
b.) Flat file databases are prevalent today because they provide relational functions.
c.) The flat file design is a single table database. -
correct answer The flat file design is a single table database
WHAT means that the data is accurate and consistent through its use and application time?
a.) Data integrity
b.) Normalization
,c.) Fidelity -
correct answer Data integrity
A database schema can be represented by which model?
a.) ERD (Entity-relationship Diagram)
b.) Data Repository
c.) Foreign Keys -
correct answer ERD
During the database design process, WHAT takes place to eliminate data redundancy?
a.) Normalization
b.) Integrity review
c.) Redundancy elimination -
correct answer Normalization
Why did relational database models replace hierarchical database models in business applications?
a.) Relational databases don't use SQL, which is used in hierarchical databases.
b.) Relational databases have simpler table relationships than hierarchical databases.
c.) Relational databases are less expensive than hierarchical databases. -
correct answer Relational databases have simpler table relationships than hierarchical databases
Big Data database size is considered to be in WHAT size level?
a.) Petabyte
b.) Megabyte
, c.) Terabyte -
correct answer Petabyte
Why are data warehouses beneficial to business managers?
a.) Data warehouses store operational data.
b.) Data warehouses increase the effectiveness of OLTP databases.
c.) Data warehouses can be mined or analyzed for trends or patterns. -
correct answer Data warehouses can be mined or analyzed for trends or patterns
What is the best definition of data integrity?
a.) Data integrity means data is current.
b.) Data integrity is a process to ensure data is not corrupted.
c.) Data integrity means data is secure and reproducible. -
correct answer Data integrity is a process to ensure data is not corrupted
It is good practice to do WHAT to data that is backed up on a regular basis?
a.) Reduce
b.) Copy
c.) Duplicate -
correct answer Reduce
Why is it not good practice to perform analytics on an online transaction processing database?
