WGU D427 Practice Questions
Accurate Answers
_______________ ensures the consistency and validity of relationships between
tables. It dictates that foreign key values in one table must either be null or match
primary key values in another table (or the same table in the case of self-
referencing relationships) correct answer Referential integrity
A column in Table B has been indexed? Which action would cause the index to be
updated? correct answer A row is deleted from Table B
Consider the following database table Order with the following columns:
OrderID (Primary Key)
CustomerID
CustomerName
OrderDate
ProductID
ProductName
Quantity
Which of the following normal forms does the Order table currently satisfy IF:
1) Each OrderID has a unique value (i.e. is a primary key)
2) Each entry in the table is atomic (no repeating groups or arrays). correct
answer First Normal Form
How are weak entities represented in an ER Diagram? correct answer With a
double rectangle
, How does a hash table determine the bucket containing each row? correct
answer Using a hash function and hash key
In a unary relationship, what kind of relationship is described? correct answer A
relationship where an entity is related to itself
In ER modeling, what describes the relationship between a salesperson and an
office space/cubicle? correct answer One-to-One
In SQL, which command is used to add a row of new data into a table? correct
answer INSERT INTO
In which normal form are all non-key attributes fully functionally dependent on
the primary key? correct answer 3NF
In which type of table is no specific order imposed on rows? correct answer Heap
table
MySQL architecture is organized into how many layers? correct answer Four
MySQL Workbench is designed for: correct answer Both database administrators
and users
The BETWEEN operator checks if a value is: correct answer Between an inclusive
range of two values
Accurate Answers
_______________ ensures the consistency and validity of relationships between
tables. It dictates that foreign key values in one table must either be null or match
primary key values in another table (or the same table in the case of self-
referencing relationships) correct answer Referential integrity
A column in Table B has been indexed? Which action would cause the index to be
updated? correct answer A row is deleted from Table B
Consider the following database table Order with the following columns:
OrderID (Primary Key)
CustomerID
CustomerName
OrderDate
ProductID
ProductName
Quantity
Which of the following normal forms does the Order table currently satisfy IF:
1) Each OrderID has a unique value (i.e. is a primary key)
2) Each entry in the table is atomic (no repeating groups or arrays). correct
answer First Normal Form
How are weak entities represented in an ER Diagram? correct answer With a
double rectangle
, How does a hash table determine the bucket containing each row? correct
answer Using a hash function and hash key
In a unary relationship, what kind of relationship is described? correct answer A
relationship where an entity is related to itself
In ER modeling, what describes the relationship between a salesperson and an
office space/cubicle? correct answer One-to-One
In SQL, which command is used to add a row of new data into a table? correct
answer INSERT INTO
In which normal form are all non-key attributes fully functionally dependent on
the primary key? correct answer 3NF
In which type of table is no specific order imposed on rows? correct answer Heap
table
MySQL architecture is organized into how many layers? correct answer Four
MySQL Workbench is designed for: correct answer Both database administrators
and users
The BETWEEN operator checks if a value is: correct answer Between an inclusive
range of two values
