.png){kind=logo}
WGU D426 Objective Assessment ( 2026/2027 Update) Data Management Foundations Questions and Answers
WGU D426 Objective Assessment (
2026/2027 Update) Data Management
Foundations Questions and
Answers
Q: The storage manager translates
Answer:
the query processor instructions into low-lev- el file-system commands that modify or retrieve
data
Q: Database sizes range from
Answer:
from megabytes to many terabytes,
Q: the storage manager uses what to quickly locate data
Answer:
indexes
Q: Metadata is
Answer:
data about the database, such as column names and the number of rows in each table.
Q: A relational database stores
Answer:
data in tables, columns, and rows, similar to a spreadsheet.
Q: All relational database systems support what query language model
Answer:
SQL
Q: Relational systems are ideal for
Answer:
databases that require an accurate record of every transaction, such as banking, airline
reservation systems, and student records.
Q: The newer non-relational systems are called
Answer:
NoSQL, for 'not only SQL'
Q: NoSQL, for 'not only SQL' is optimized for
Answer:
big business
Q: MongoDB is what type of database
Answer:
NoSQL
Q: An SQL statement is a
Answer:
database command, such as a query that inserts, selects, updates, or deletes data:
Q: INSERT
Answer:
inserts rows into a table.
Q: SELECT
Answer:
retrieves data from a table.
Q: UPDATE
Answer:
modifies data in a table.
Q: DELETE
Answer:
deletes rows from a table.
Q: The SQL CREATE TABLE statement creates
Answer:
creates a new table by specify- ing the table and column names.
Q: Each column is assigned a data type that indicates
Answer:
the format of column values. Data types can be numeric, textual, or complex
Q: INT
Answer:
stores integer values.
Q: DECIMAL
Answer:
stores fractional numeric values.
Q: VARCHAR
Answer:
stores textual values
Q: DATE
Answer:
stores year, month, and day.
Q: For large, complex databases, the process has three phases
Answer:
1.Analysis
2.Logical design
3.Physical design
Q: The analysis phase specifies
Answer:
.png)