WGU D427 DATA MANAGEMENT COMPREHENSIVE
QUESTIONS AND CORRECT ANSWERS PRE-ASSESSMENT
(GRADE A+) 2024 NEWEST UPDATE
Authorization - (correct answer) Which requirement within large, complex databases
ensures users have limited access to the database?
Conceptual design - (correct answer) Which design type specifi es database
requirements without regard to a specifi c database system?
They are logical constraints that ensure the data is valid. - (correct answer) What
characterizes the rules of relational databases?
When an SQL statement is syntactically incorrect - (correct answer) Which event will
result in an error code and error description when using MySQL Server?
INT - (correct answer) Which data type should be used to store whole integer
values, such as age?
MySQL Command-Line Client - (correct answer) Which text-based interface is
included in the MySQL Server Download?
MySQL - (correct answer) Which database system includes the World database
during its installation?
Structured Query Language - (correct answer) What is the standardized language of
relational database systems?
Data Control Language (DCL) - (correct answer) Which SQL sublanguage is used to
manage database access?
Data Transaction Language (DTL) - (correct answer) Which SQL sublanguage is
used to roll back database changes?
hh:mm:ss - (correct answer) Which format is used by the TIME data type in
MySQL?
OR - (correct answer) Which MySQL operator is the last in the order of operator
precedence?
<= - (correct answer) Which operator is used to compare columns from the left and
right tables in MySQL?
CROSS - (correct answer) Which type of join combines two tables without
comparing columns?
, Equijoin - (correct answer) Which type of join compares columns using only the =
operator?
EQUIJOIN - (correct answer) Which type of join is demonstrated by the following
query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
In a nested query, the outer query is evaluated first. - (correct answer) What is
another name for a subquery?
IN - (correct answer) Which operator is used to compare against a list of values
when determining a match in a WHERE clause?
% - (correct answer) Which wildcard character is used to represent zero or more
characters when searching for a specified pattern using a LIKE operator?
MIN - (correct answer) Which function is considered an aggregating function in
SQL?
GROUP BY - (correct answer) Which clause or function is used with aggregate
functions to produce summary rows?
Inner Join - (correct answer) Which type of join returns only the matching values
when selecting rows from two or more tables?
Inner Join - (correct answer) Which join type selects only matching left and right
table rows?
Materialized View - (correct answer) Which phrase refers to the view in which data
is persisted and is automatically changed as the underlying data is changed?
UPDATE Employee SET Salary = 50000 WHERE ID = 1; - (correct answer) Which
SQL command uses the correct syntax to update the salary of an employee in the
Employee table?
Metadata - (correct answer) What describes elements such as column name and
data type?
Tuple - (correct answer) Which term identifies an ordered collection of elements
enclosed in parenthesis in a tablespace?
SELECT name, salary FROM Employee WHERE salary > 50000ORDER BY salary
DESC; - (correct answer) Which SQL command uses the correct syntax to select
QUESTIONS AND CORRECT ANSWERS PRE-ASSESSMENT
(GRADE A+) 2024 NEWEST UPDATE
Authorization - (correct answer) Which requirement within large, complex databases
ensures users have limited access to the database?
Conceptual design - (correct answer) Which design type specifi es database
requirements without regard to a specifi c database system?
They are logical constraints that ensure the data is valid. - (correct answer) What
characterizes the rules of relational databases?
When an SQL statement is syntactically incorrect - (correct answer) Which event will
result in an error code and error description when using MySQL Server?
INT - (correct answer) Which data type should be used to store whole integer
values, such as age?
MySQL Command-Line Client - (correct answer) Which text-based interface is
included in the MySQL Server Download?
MySQL - (correct answer) Which database system includes the World database
during its installation?
Structured Query Language - (correct answer) What is the standardized language of
relational database systems?
Data Control Language (DCL) - (correct answer) Which SQL sublanguage is used to
manage database access?
Data Transaction Language (DTL) - (correct answer) Which SQL sublanguage is
used to roll back database changes?
hh:mm:ss - (correct answer) Which format is used by the TIME data type in
MySQL?
OR - (correct answer) Which MySQL operator is the last in the order of operator
precedence?
<= - (correct answer) Which operator is used to compare columns from the left and
right tables in MySQL?
CROSS - (correct answer) Which type of join combines two tables without
comparing columns?
, Equijoin - (correct answer) Which type of join compares columns using only the =
operator?
EQUIJOIN - (correct answer) Which type of join is demonstrated by the following
query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
In a nested query, the outer query is evaluated first. - (correct answer) What is
another name for a subquery?
IN - (correct answer) Which operator is used to compare against a list of values
when determining a match in a WHERE clause?
% - (correct answer) Which wildcard character is used to represent zero or more
characters when searching for a specified pattern using a LIKE operator?
MIN - (correct answer) Which function is considered an aggregating function in
SQL?
GROUP BY - (correct answer) Which clause or function is used with aggregate
functions to produce summary rows?
Inner Join - (correct answer) Which type of join returns only the matching values
when selecting rows from two or more tables?
Inner Join - (correct answer) Which join type selects only matching left and right
table rows?
Materialized View - (correct answer) Which phrase refers to the view in which data
is persisted and is automatically changed as the underlying data is changed?
UPDATE Employee SET Salary = 50000 WHERE ID = 1; - (correct answer) Which
SQL command uses the correct syntax to update the salary of an employee in the
Employee table?
Metadata - (correct answer) What describes elements such as column name and
data type?
Tuple - (correct answer) Which term identifies an ordered collection of elements
enclosed in parenthesis in a tablespace?
SELECT name, salary FROM Employee WHERE salary > 50000ORDER BY salary
DESC; - (correct answer) Which SQL command uses the correct syntax to select
