WGU D426 DATA MANAGEMENT
FOUNDATIONS FINAL 4 2026 FULL SOLVED
QUESTIONS ANSWERS RELATIONAL DATABASE
CONCEPTS REVIEW SHEET
◉ Catalog/Data Dictionary/Repository.
Answer: A directory of tables, columns, indexes, and other database
objects.
◉ Relational Database.
Answer: Stores data in tables, columns, and rows, SIMILAR to a
spreadsheet. It also supports SQL. Made up of relations.
◉ NoSQL.
Answer: A new generation of DBMS that is NOT based on the
traditional relational database model.
◉ CRUD.
Answer: Acronym for actions that can be performed by a query.
◉ SQL Statement.
,Answer: A database command such as a query that inserts, retrieves,
updates, or deletes data. Composed of one or more clauses.
◉ INSERT.
Answer: Inserts rows into a table.
◉ SELECT.
Answer: Retrieves data from a table.
◉ UPDATE.
Answer: Modifies data in a table.
◉ DELETE.
Answer: Deletes rows from a table.
◉ CREATE TABLE.
Answer: Creates a new table by specifying the table and column
names.
◉ Data Type.
Answer: Indicates the TYPE of data that can be stored in a field of a
column.
, ◉ Data Independence.
Answer: Allows database administrators to improve query
performance by changing the organization of data on storage
devices, without affecting query results or changes to programs.
◉ Database Design.
Answer: A specification of database objects such as tables, columns
data types, and indexes. Also refers to the process used to develop
the specifications.
◉ Metadata.
Answer: Data ABOUT the database, such as column names and the
number of rows in each table.
◉ Database Design - Analysis.
Answer: This phase specifies database requirements without regard
to a specific database system. May also be referred to as conceptual
design, entity-relationship modeling, and requirements definition.
◉ Database Design - Logical Design.
Answer: This phase implements database requirements in a specific
database system. Depicted in a table diagram.
FOUNDATIONS FINAL 4 2026 FULL SOLVED
QUESTIONS ANSWERS RELATIONAL DATABASE
CONCEPTS REVIEW SHEET
◉ Catalog/Data Dictionary/Repository.
Answer: A directory of tables, columns, indexes, and other database
objects.
◉ Relational Database.
Answer: Stores data in tables, columns, and rows, SIMILAR to a
spreadsheet. It also supports SQL. Made up of relations.
◉ NoSQL.
Answer: A new generation of DBMS that is NOT based on the
traditional relational database model.
◉ CRUD.
Answer: Acronym for actions that can be performed by a query.
◉ SQL Statement.
,Answer: A database command such as a query that inserts, retrieves,
updates, or deletes data. Composed of one or more clauses.
◉ INSERT.
Answer: Inserts rows into a table.
◉ SELECT.
Answer: Retrieves data from a table.
◉ UPDATE.
Answer: Modifies data in a table.
◉ DELETE.
Answer: Deletes rows from a table.
◉ CREATE TABLE.
Answer: Creates a new table by specifying the table and column
names.
◉ Data Type.
Answer: Indicates the TYPE of data that can be stored in a field of a
column.
, ◉ Data Independence.
Answer: Allows database administrators to improve query
performance by changing the organization of data on storage
devices, without affecting query results or changes to programs.
◉ Database Design.
Answer: A specification of database objects such as tables, columns
data types, and indexes. Also refers to the process used to develop
the specifications.
◉ Metadata.
Answer: Data ABOUT the database, such as column names and the
number of rows in each table.
◉ Database Design - Analysis.
Answer: This phase specifies database requirements without regard
to a specific database system. May also be referred to as conceptual
design, entity-relationship modeling, and requirements definition.
◉ Database Design - Logical Design.
Answer: This phase implements database requirements in a specific
database system. Depicted in a table diagram.
