WGU C803 : DATA TYPES AND
STRUCTURES ACTUAL EXAM PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
◍ big data.
Answer: A movement to find new and better ways to manage large amounts
of web-generated data and derive business insight from it, while
simultaneously providing high performance and scalability at a reasonable
cost
◍ Primary methods of summarizing ordinal data.
Answer: Counting and grouping, proportion, ranking.
◍ Characteristics of Ratio Data.
Answer: Absolute 'zero' in ratio data is the point of origin. Zero means
naught.
◍ Categorical Data.
Answer: Data that is represented by words—such as grouping a collection of
people by gender or categorizing transaction types.
◍ Examples of Ordinal Data.
Answer: Letter grades (A, B, C, D, F) and Olympic medals (gold, silver,
bronze).
◍ fourth normal form (4NF).
Answer: A table that is in 3NF and contains no multiple independent sets of
multivalued dependencies
◍ relational diagram.
Answer: A graphical representation of a relational database's entities, the
attributes within those entities, and the relationships among the entities
,◍ DELETE.
Answer: A SQL command that allows data rows to be permanently removed
from a table
◍ master data management (MDM).
Answer: In business intelligence, a collection of concepts, techniques, and
processes for the proper identification, definition, and management of data
elements within an organization
◍ Definition of a String.
Answer: A collection of one or more characters that are stored as categorical
data.
◍ Examples of Interval Data.
Answer: A thermometer or SAT scores.
◍ slice and dice.
Answer: The ability to focus on slices of a data cube (drill down or roll up)
to perform a more detailed analysis
◍ Types of Categorical Data.
Answer: Two types: Ordinal and Nominal.
◍ Types of Numerical Data.
Answer: Two types: Interval and Ratio.
◍ Primary method of summarizing nominal data.
Answer: Counting and grouping, proportion.
◍ client node.
Answer: One of the three types of nodes used in the Hadoop Distributed File
System (HDFS). It acts as the interface between the user application and the
HDFS.
◍ Unstructured Data.
Answer: Data without internal organization (or structure).
◍ denormilization.
, Answer: A process by which a table is changed from a higher-level normal
form to a lower-level normal form, usually to increase processing speed
◍ AND.
Answer: The SQL logical operator used to link multiple conditional
expressions in a WHERE or HAVING clause. It requires that all conditional
expressions evaluate to true
◍ Interval Data.
Answer: Numerical data measured along with a scale.
◍ Ranking.
Answer: A position on a scale.
◍ Data Dictionary.
Answer: A centralized repository of information about data containing a
separate record for each field/variable in the database.
◍ data node.
Answer: One of the three types of nodes used in the Hadoop Distributed File
System (HDFS). It stores fixed-size data blocks.
◍ data visualization.
Answer: Abstracting data to provide information in a visual format that
enhances the user's ability to effective comprehend the meaning of the data
◍ Ordinal Data.
Answer: Categorical data with natural, ranked categories.
◍ Strings / Text Data.
Answer: String, text, short text, long text, or alphanumeric.
◍ abstract data type (ADT).
Answer: Data type that describes a set of similar objects with shared and
encapsulated data representation and methods. It is generally used to
describe complex objects
◍ FROM.
Answer: A SQL clause that specifies the table or tables from which data is
, to be retrieved
◍ client.
Answer: Any process that requests specific services from server processes in
a client/server environment
◍ DROP INDEX.
Answer: A SQL command used to delete database objects such as tables,
views, indexes, and users
◍ iterative process.
Answer: A process based on repetition of steps and procedures
◍ Characteristics of Interval Data.
Answer: Zero does not mean naught. No absolute zero.
◍ Nominal Data.
Answer: Categorical data that cannot be ranked.
◍ external schema.
Answer: The specific representation of an external view; the end user's view
of the data environment
◍ composite entity.
Answer: An entity designed to transform a M:N relationship into two 1:M
relationships. It's primary key comprises at least the primary key of the
entities that it connects.
◍ Example of Nominal Data.
Answer: Transaction type (purchase, return).
◍ NoSQL.
Answer: A new generation of database management systems that is not
based on the traditional relational database model. It stores structured and
unstructured data in efficient ways.
◍ Numerical Data.
Answer: Data represented by meaningful numbers, such as transaction
amount, age, or the score on an exam.
STRUCTURES ACTUAL EXAM PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
◍ big data.
Answer: A movement to find new and better ways to manage large amounts
of web-generated data and derive business insight from it, while
simultaneously providing high performance and scalability at a reasonable
cost
◍ Primary methods of summarizing ordinal data.
Answer: Counting and grouping, proportion, ranking.
◍ Characteristics of Ratio Data.
Answer: Absolute 'zero' in ratio data is the point of origin. Zero means
naught.
◍ Categorical Data.
Answer: Data that is represented by words—such as grouping a collection of
people by gender or categorizing transaction types.
◍ Examples of Ordinal Data.
Answer: Letter grades (A, B, C, D, F) and Olympic medals (gold, silver,
bronze).
◍ fourth normal form (4NF).
Answer: A table that is in 3NF and contains no multiple independent sets of
multivalued dependencies
◍ relational diagram.
Answer: A graphical representation of a relational database's entities, the
attributes within those entities, and the relationships among the entities
,◍ DELETE.
Answer: A SQL command that allows data rows to be permanently removed
from a table
◍ master data management (MDM).
Answer: In business intelligence, a collection of concepts, techniques, and
processes for the proper identification, definition, and management of data
elements within an organization
◍ Definition of a String.
Answer: A collection of one or more characters that are stored as categorical
data.
◍ Examples of Interval Data.
Answer: A thermometer or SAT scores.
◍ slice and dice.
Answer: The ability to focus on slices of a data cube (drill down or roll up)
to perform a more detailed analysis
◍ Types of Categorical Data.
Answer: Two types: Ordinal and Nominal.
◍ Types of Numerical Data.
Answer: Two types: Interval and Ratio.
◍ Primary method of summarizing nominal data.
Answer: Counting and grouping, proportion.
◍ client node.
Answer: One of the three types of nodes used in the Hadoop Distributed File
System (HDFS). It acts as the interface between the user application and the
HDFS.
◍ Unstructured Data.
Answer: Data without internal organization (or structure).
◍ denormilization.
, Answer: A process by which a table is changed from a higher-level normal
form to a lower-level normal form, usually to increase processing speed
◍ AND.
Answer: The SQL logical operator used to link multiple conditional
expressions in a WHERE or HAVING clause. It requires that all conditional
expressions evaluate to true
◍ Interval Data.
Answer: Numerical data measured along with a scale.
◍ Ranking.
Answer: A position on a scale.
◍ Data Dictionary.
Answer: A centralized repository of information about data containing a
separate record for each field/variable in the database.
◍ data node.
Answer: One of the three types of nodes used in the Hadoop Distributed File
System (HDFS). It stores fixed-size data blocks.
◍ data visualization.
Answer: Abstracting data to provide information in a visual format that
enhances the user's ability to effective comprehend the meaning of the data
◍ Ordinal Data.
Answer: Categorical data with natural, ranked categories.
◍ Strings / Text Data.
Answer: String, text, short text, long text, or alphanumeric.
◍ abstract data type (ADT).
Answer: Data type that describes a set of similar objects with shared and
encapsulated data representation and methods. It is generally used to
describe complex objects
◍ FROM.
Answer: A SQL clause that specifies the table or tables from which data is
, to be retrieved
◍ client.
Answer: Any process that requests specific services from server processes in
a client/server environment
◍ DROP INDEX.
Answer: A SQL command used to delete database objects such as tables,
views, indexes, and users
◍ iterative process.
Answer: A process based on repetition of steps and procedures
◍ Characteristics of Interval Data.
Answer: Zero does not mean naught. No absolute zero.
◍ Nominal Data.
Answer: Categorical data that cannot be ranked.
◍ external schema.
Answer: The specific representation of an external view; the end user's view
of the data environment
◍ composite entity.
Answer: An entity designed to transform a M:N relationship into two 1:M
relationships. It's primary key comprises at least the primary key of the
entities that it connects.
◍ Example of Nominal Data.
Answer: Transaction type (purchase, return).
◍ NoSQL.
Answer: A new generation of database management systems that is not
based on the traditional relational database model. It stores structured and
unstructured data in efficient ways.
◍ Numerical Data.
Answer: Data represented by meaningful numbers, such as transaction
amount, age, or the score on an exam.
