1. What Is a software that reads and writes data in a Database management
database? system or DBMS
2. What is a computer programming language for writ- Query language
ing database queries?
3. What is a command for a database that typically Query
inserts new data, retrieves data, updates data, or
deletes data from a database
4. What is a group of queries that must be either com- A transaction
pleted or rejected as a whole?
5. What Interprets queries, creates a plan to modify the A query processor
database or retrieve data, and returns query results to
the application?
6. What translates the query processor instructions into Store Manager
low-level file-system commands that modify or re-
trieve data?
7. What ensures transactions are properly executed? Transaction Manager
8. What is a file containing a complete record of all in- The log
serts, updates, and deletes processed by the data-
base?
9. What is a directory of tables, columns, indexes, and Catalog
other database objects?
10. What is a column, used to identify individual rows of a A key
table?
11.
, WGU D426 Exam Questions And Answers For A+ Score 2026|2027
Which phase implements database requirements in a Database Logical design
specific database system? phase
12. Which phase specifies database objects such as ta- Database design phase
bles, columns, data types, and indexes?
13. Which phase specifies database requirements without Database analysis phase
regard to a specific database system?
14. Which phase adds indexes and specifies how tables Database physical design
are organized on storage media? phase
15. What is the name of a leading relational database MySQL
system that sponsored by Oracle?
16. What is a conceptual framework for database sys- Database model
tems, with three parts?
17. In a database model, what prescribes how data is Data structures
organized?
18. In a database mode, what manipulates data struc- Operations
tures?
19. In a database mode, what governs valid data? Rules
20. What command selects a subset of rows of a table? Select
21. What command eliminates one or more columns of a Project
table?
22. What command lists all combination of rows of two Product
tables?
23. Join