WGU D326 ADVANCED DATA
MANAGEMENT ACTUAL EXAM PAPER
2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ MySQL Workbench.
Answer: installed with MySQL Server and allows developers to execute
SQL commands using an editor
◍ Remove all data from a table.
Answer: DELETE FROM TableName;
◍ row-oriented storage.
Answer: to minimize block transfers, relational databases usually store an
entire row within one block, which is called-row oriented storage
◍ identifying attyribute.
Answer: this kind of attribute is unique, singular and required
◍ SHOW COLUMNS FROM TableName.
Answer: lists all columns in the TableName table of the default database
◍ UNION.
Answer: this keyword combines the two results into one table
◍ UNIQUE.
Answer: this constraint ensures that values in a column, or group of
columns, are unique.
◍ subtype table.
Answer: a subtype entity becomes a subtype table
◍ Return specific records from a table.
, Answer: SELECT Column1, Column2FROM TableNameWHERE
Condition;
◍ tablespace.
Answer: a database object that maps one or more tables to a single file
◍ CREATE TABLE.
Answer: command that creates a new table by specifying the table and
column names
◍ cross-join.
Answer: combines two tables without comparing columns
◍ subquery / nested query / inner query.
Answer: three names for a query within another SQL query
◍ RIGHT JOIN.
Answer: selects all right table rows, but only matching left table rows
◍ tuple.
Answer: ordered collection of elements enclosed in parentheses
◍ column constraint.
Answer: this appears after the column name and data type in a CREATE
TABLE statement. They govern values in a single column
◍ logical index.
Answer: a single- or multi-level index in which pointers to table blocks are
replaced with primary key values
◍ second normal form.
Answer: a table is in second normal form whe all non-key columns depend
on the whole primary key
◍ Create a table with constraint functions.
Answer: CREATE TABLE TableName (ColumnName1 DataType
Constraint1 Constraint2,ColumnName2 DataType Constraint1);
◍ relationship maximum.
, Answer: the greatest number of instances of one entity that can relate to a
single instance of another entity
◍ database designer.
Answer: determines the format of each data element and the overall database
structure.
◍ sectors.
Answer: Magnetic disk groups data in sectors, traditionally 512 bytes per
sector but 4 kilobytes with newer disk formats
◍ alias.
Answer: a temporary name assigned to a column or a table
◍ IN.
Answer: This operator is used in a WHERE clause to determine if a value
matches one of several values
◍ relationship.
Answer: a statement about two entities
◍ storage manager.
Answer: translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
◍ query processor.
Answer: interprets queries, creates a plan to modify the databse or retrieve
data, and returns query results to the application.
◍ cardinality.
Answer: this refers to maxima and minima of relationships and attributes in
entity relationship modeling
◍ slow query log.
Answer: this is a file that records all long-running queries submitted to the
database
◍ column-oriented /columnar storage.
Answer: each block stores values for a single column only
, ◍ logical design.
Answer: implements database requirements in a specific database system.
converts the ERD into tables, columns and keys
◍ MIN ().
Answer: this aggregate function finds the minimum value in the set
◍ Use a sub-query.
Answer: SELECT Column1, Column2, Column3...FROM
TableNameWHERE Column OPERATOR (Select FUNCTION(Column)
FROM TableName);
◍ subtype entity / supertype entity.
Answer: a subtype entity is a subset of another entity type, called the
supertype entity
◍ execution plan.
Answer: a detailed, low-level sequence of steps that specify exactly how to
process a query
◍ key.
Answer: a column used to identify individual rows of a table.
◍ normal forms.
Answer: rules for designing tables with less redundancy
◍ horizontal parition.
Answer: a subset of table rows
◍ COUNT().
Answer: This aggregate function counts the numbers of rows in the set
◍ Aggregate function (single value output).
Answer: SELECT Function(Column) AS NewColumnNameFROM
TableName;
◍ transfer rate.
Answer: the speed at which data is read or written, following initial access
MANAGEMENT ACTUAL EXAM PAPER
2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ MySQL Workbench.
Answer: installed with MySQL Server and allows developers to execute
SQL commands using an editor
◍ Remove all data from a table.
Answer: DELETE FROM TableName;
◍ row-oriented storage.
Answer: to minimize block transfers, relational databases usually store an
entire row within one block, which is called-row oriented storage
◍ identifying attyribute.
Answer: this kind of attribute is unique, singular and required
◍ SHOW COLUMNS FROM TableName.
Answer: lists all columns in the TableName table of the default database
◍ UNION.
Answer: this keyword combines the two results into one table
◍ UNIQUE.
Answer: this constraint ensures that values in a column, or group of
columns, are unique.
◍ subtype table.
Answer: a subtype entity becomes a subtype table
◍ Return specific records from a table.
, Answer: SELECT Column1, Column2FROM TableNameWHERE
Condition;
◍ tablespace.
Answer: a database object that maps one or more tables to a single file
◍ CREATE TABLE.
Answer: command that creates a new table by specifying the table and
column names
◍ cross-join.
Answer: combines two tables without comparing columns
◍ subquery / nested query / inner query.
Answer: three names for a query within another SQL query
◍ RIGHT JOIN.
Answer: selects all right table rows, but only matching left table rows
◍ tuple.
Answer: ordered collection of elements enclosed in parentheses
◍ column constraint.
Answer: this appears after the column name and data type in a CREATE
TABLE statement. They govern values in a single column
◍ logical index.
Answer: a single- or multi-level index in which pointers to table blocks are
replaced with primary key values
◍ second normal form.
Answer: a table is in second normal form whe all non-key columns depend
on the whole primary key
◍ Create a table with constraint functions.
Answer: CREATE TABLE TableName (ColumnName1 DataType
Constraint1 Constraint2,ColumnName2 DataType Constraint1);
◍ relationship maximum.
, Answer: the greatest number of instances of one entity that can relate to a
single instance of another entity
◍ database designer.
Answer: determines the format of each data element and the overall database
structure.
◍ sectors.
Answer: Magnetic disk groups data in sectors, traditionally 512 bytes per
sector but 4 kilobytes with newer disk formats
◍ alias.
Answer: a temporary name assigned to a column or a table
◍ IN.
Answer: This operator is used in a WHERE clause to determine if a value
matches one of several values
◍ relationship.
Answer: a statement about two entities
◍ storage manager.
Answer: translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
◍ query processor.
Answer: interprets queries, creates a plan to modify the databse or retrieve
data, and returns query results to the application.
◍ cardinality.
Answer: this refers to maxima and minima of relationships and attributes in
entity relationship modeling
◍ slow query log.
Answer: this is a file that records all long-running queries submitted to the
database
◍ column-oriented /columnar storage.
Answer: each block stores values for a single column only
, ◍ logical design.
Answer: implements database requirements in a specific database system.
converts the ERD into tables, columns and keys
◍ MIN ().
Answer: this aggregate function finds the minimum value in the set
◍ Use a sub-query.
Answer: SELECT Column1, Column2, Column3...FROM
TableNameWHERE Column OPERATOR (Select FUNCTION(Column)
FROM TableName);
◍ subtype entity / supertype entity.
Answer: a subtype entity is a subset of another entity type, called the
supertype entity
◍ execution plan.
Answer: a detailed, low-level sequence of steps that specify exactly how to
process a query
◍ key.
Answer: a column used to identify individual rows of a table.
◍ normal forms.
Answer: rules for designing tables with less redundancy
◍ horizontal parition.
Answer: a subset of table rows
◍ COUNT().
Answer: This aggregate function counts the numbers of rows in the set
◍ Aggregate function (single value output).
Answer: SELECT Function(Column) AS NewColumnNameFROM
TableName;
◍ transfer rate.
Answer: the speed at which data is read or written, following initial access
