Data Management - Foundations - D426 WGU Exam | 183 Actual Question
And Answers | Latest Update | 2026-2027
1. Data Numeric, textual, visual, or audio information that describes real-world systems.
It is collected and processed to aid in a variety of tasks.
2. Analog Data Most common before computers. Audio was recorded as vibrations impressed on
vinyl disks.
3. Digital Data Most common today. Encoded as 0s and 1s on electronic magnetic data.
4. Database A collection of data in structured format. In principle, can be stored on paper or
even clay tablets.
5. Database System Software that reads and writes in a database.
(DBMS)
6. Query A request to retrieve or change data in a database. Typically inserts new data,
retrieves data, updates, data, or deletes data from a database.
7. Query Language Specialized programming language designed specifically for database systems.
Reads and writes data eflciently.
8. Database Appli- Software that HELPS business users interact with database systems.
cation
9. Database Admin- What role am I?
istrator
Responsible for securing the database system against unauthorized users. They
enforce procedures for user access and database system availability.
10. Database De- What role am I?
signer
Determines the format of each data element AND the overall database STRUC-
TURE. Must balance priorities like including storage, response time, and support
for rules that govern the data.
, Data Management - Foundations - D426 WGU Exam | 183 Actual Question
And Answers | Latest Update | 2026-2027
11. Database Pro- What role am I?
grammer
Develop programs that utilize a database and write applications that combine
query languages and general purpose programming language.
12. Database User What role am I?
A consumer of data in a database. They request, update, or use stored data to
generate reports or information.
13. Transaction A group of queries that MUST be completed or rejected as a whole.
14. Architecture Describes the internal components AND the relationships between components.
15. Query Processor Interprets queries, creates a plan to modify the database or retrieve the data, and
returns query results to the application. Performs query optimization.
16. Query Optimiza- Ensures eflcient instructions are executed on the data from the Query Processor.
tion
17. Storage Manager Translates the query processor instructions into low-level file-system commands
that modify OR retrieve data. Uses indexes to quickly locate data.
18. Transaction Man- Ensures transactions are properly executed. Prevents conflicts between concur-
ager rent transactions. Also restores the database to a consistent state in the event of
a failure.
19. Log A file containing a complete record of ALL inserts, updates, and deletes processed
by the database. The records can be used to restore a database.
20. Catalog/Data A directory of tables, columns, indexes, and other database objects.
Dictionary/Repos-
itory
, Data Management - Foundations - D426 WGU Exam | 183 Actual Question
And Answers | Latest Update | 2026-2027
Study online at https://quizlet.com/_isofua
21. Relational Data- Stores data in tables, columns, and rows, SIMILAR to a spreadsheet. It also
base supports SQL. Made up of relations.
22. NoSQL A new generation of DBMS that is NOT based on the traditional relational database
model.
23. CRUD Acronym for actions that can be performed by a query.
24. SQL Statement A database command such as a query that inserts, retrieves, updates, or deletes
data. Composed of one or more clauses.
25. INSERT Inserts rows into a table.
26. SELECT Retrieves data from a table.
27. UPDATE Modifies data in a table.
28. DELETE Deletes rows from a table.
29. CREATE TABLE Creates a new table by specifying the table and column names.
30. Data Type Indicates the TYPE of data that can be stored in a field of a column.
31. Data Indepen- Allows database administrators to improve query performance by changing the
dence organization of data on storage devices, without attecting query results or changes
to programs.
32. Database Design A specification of database objects such as tables, columns data types, and
indexes. Also refers to the process used to develop the specifications.
33. Metadata Data ABOUT the database, such as column names and the number of rows in each
table.
34.
And Answers | Latest Update | 2026-2027
1. Data Numeric, textual, visual, or audio information that describes real-world systems.
It is collected and processed to aid in a variety of tasks.
2. Analog Data Most common before computers. Audio was recorded as vibrations impressed on
vinyl disks.
3. Digital Data Most common today. Encoded as 0s and 1s on electronic magnetic data.
4. Database A collection of data in structured format. In principle, can be stored on paper or
even clay tablets.
5. Database System Software that reads and writes in a database.
(DBMS)
6. Query A request to retrieve or change data in a database. Typically inserts new data,
retrieves data, updates, data, or deletes data from a database.
7. Query Language Specialized programming language designed specifically for database systems.
Reads and writes data eflciently.
8. Database Appli- Software that HELPS business users interact with database systems.
cation
9. Database Admin- What role am I?
istrator
Responsible for securing the database system against unauthorized users. They
enforce procedures for user access and database system availability.
10. Database De- What role am I?
signer
Determines the format of each data element AND the overall database STRUC-
TURE. Must balance priorities like including storage, response time, and support
for rules that govern the data.
, Data Management - Foundations - D426 WGU Exam | 183 Actual Question
And Answers | Latest Update | 2026-2027
11. Database Pro- What role am I?
grammer
Develop programs that utilize a database and write applications that combine
query languages and general purpose programming language.
12. Database User What role am I?
A consumer of data in a database. They request, update, or use stored data to
generate reports or information.
13. Transaction A group of queries that MUST be completed or rejected as a whole.
14. Architecture Describes the internal components AND the relationships between components.
15. Query Processor Interprets queries, creates a plan to modify the database or retrieve the data, and
returns query results to the application. Performs query optimization.
16. Query Optimiza- Ensures eflcient instructions are executed on the data from the Query Processor.
tion
17. Storage Manager Translates the query processor instructions into low-level file-system commands
that modify OR retrieve data. Uses indexes to quickly locate data.
18. Transaction Man- Ensures transactions are properly executed. Prevents conflicts between concur-
ager rent transactions. Also restores the database to a consistent state in the event of
a failure.
19. Log A file containing a complete record of ALL inserts, updates, and deletes processed
by the database. The records can be used to restore a database.
20. Catalog/Data A directory of tables, columns, indexes, and other database objects.
Dictionary/Repos-
itory
, Data Management - Foundations - D426 WGU Exam | 183 Actual Question
And Answers | Latest Update | 2026-2027
Study online at https://quizlet.com/_isofua
21. Relational Data- Stores data in tables, columns, and rows, SIMILAR to a spreadsheet. It also
base supports SQL. Made up of relations.
22. NoSQL A new generation of DBMS that is NOT based on the traditional relational database
model.
23. CRUD Acronym for actions that can be performed by a query.
24. SQL Statement A database command such as a query that inserts, retrieves, updates, or deletes
data. Composed of one or more clauses.
25. INSERT Inserts rows into a table.
26. SELECT Retrieves data from a table.
27. UPDATE Modifies data in a table.
28. DELETE Deletes rows from a table.
29. CREATE TABLE Creates a new table by specifying the table and column names.
30. Data Type Indicates the TYPE of data that can be stored in a field of a column.
31. Data Indepen- Allows database administrators to improve query performance by changing the
dence organization of data on storage devices, without attecting query results or changes
to programs.
32. Database Design A specification of database objects such as tables, columns data types, and
indexes. Also refers to the process used to develop the specifications.
33. Metadata Data ABOUT the database, such as column names and the number of rows in each
table.
34.
