WGU D426 Data Management Foundations Final Exam Review (Latest 2024/ 2025 Update) Questions and Verified Answers Correct Grade A

What Is a software that reads and writes data in a database? Database management system or DBMS What is a computer programming language for writing database queries? Query language What is a command for a database that typically inserts new data, retrieves data, updates data, or deletes data from a database Query What is a group of queries that must be either completed or rejected as a whole? A transaction What Interprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application? A query processor What translates the query processor instructions into low-level file-system commands that modify or retrieve data? Store Manager What ensures transactions are properly executed? Transaction Manager What is a file containing a complete record of all inserts, updates, and deletes processed by the database? The log What is a directory of tables, columns, indexes, and other database objects? Catalog What is a column, used to identify individual rows of a table? A key Which phase implements database requirements in a specific database system? Database Logical design phase Which phase specifies database objects such as tables, columns, data types, and indexes? Database design phase Which phase specifies database requirements without regard to a specific database system? Database analysis phase Which phase adds indexes and specifies how tables are organized on storage media? Database physical design phase