For Expert help and assignment handling,
1
C170 WGU Data Management Applications
Practice Test Review Questions and Answers
(100% Correct Answers) Already Graded A+
In which two ways can data redundancy affect managing disk space
and calculation speed?Ans: Additional proccessing time is needed to
udate redundant data
© 2026 Assignment Expert
Redundant data takes up disk space
With which command can a database admin allow a user named Mary
Guru01 - Stuvia
to query the Patient table by executing SELECT commands on itAns:
GRANT SELECT ON PATIENT TO 'Mary' @ 'localhost'
What does the WHERE identify in basic SQL SELECT statementAns: The
rows to be included in the result set
Which condition must be in effect to use the INSERT INTO ... VALUES
syntax for an INSERT statementAns: The VALUES list must contain a value
for each attribute/column in the table
Which method creates an empty copy of a table and then populates it
from the original table?Ans: CREATE TABLE newTableName LIKE
tableName INSERT INTO newTableName SELECT * FROM tableName;
ALTER TABLE tableName action [, action] ...;
What does this syntax allow?Ans: Changing column types
, For Expert help and assignment handling,
2
Dropping indexes
What is the proper command to change a view?Ans: ALTER VIEW
Which optional clause added to a GRANT statement enables the
account to give its own privileges to other uses?Ans: WITH GRANT
OPTION
What is the correct syntax to create an index to be built on the V_STATE
© 2026 Assignment Expert
field based on the database information?Ans: ALTER TABLE 'Vendor' ADD
INDEX 'state_index ('V_STATE');
Which clause when added to the end of a statement creates an index
Guru01 - Stuvia
on the customer_id field?
Statement after foreign / primary keyAns: INDEX custid_index
(customer_id));
Which syntax is the correct way to use the DROP INDEX command to
drop a primary key from a table?Ans: DROP INDEX `PRIMARY` ON
tableName;
In order to create a relationship between the Instructor and Course
tables with two separate primary keys, what should be done?Ans:
Create a new column in the Course table for Instructor ID
What is a characteristic of a database that is normalized to be the
second normal form?Ans: There are no values that are dependent on
only part of a composite primary key
1
C170 WGU Data Management Applications
Practice Test Review Questions and Answers
(100% Correct Answers) Already Graded A+
In which two ways can data redundancy affect managing disk space
and calculation speed?Ans: Additional proccessing time is needed to
udate redundant data
© 2026 Assignment Expert
Redundant data takes up disk space
With which command can a database admin allow a user named Mary
Guru01 - Stuvia
to query the Patient table by executing SELECT commands on itAns:
GRANT SELECT ON PATIENT TO 'Mary' @ 'localhost'
What does the WHERE identify in basic SQL SELECT statementAns: The
rows to be included in the result set
Which condition must be in effect to use the INSERT INTO ... VALUES
syntax for an INSERT statementAns: The VALUES list must contain a value
for each attribute/column in the table
Which method creates an empty copy of a table and then populates it
from the original table?Ans: CREATE TABLE newTableName LIKE
tableName INSERT INTO newTableName SELECT * FROM tableName;
ALTER TABLE tableName action [, action] ...;
What does this syntax allow?Ans: Changing column types
, For Expert help and assignment handling,
2
Dropping indexes
What is the proper command to change a view?Ans: ALTER VIEW
Which optional clause added to a GRANT statement enables the
account to give its own privileges to other uses?Ans: WITH GRANT
OPTION
What is the correct syntax to create an index to be built on the V_STATE
© 2026 Assignment Expert
field based on the database information?Ans: ALTER TABLE 'Vendor' ADD
INDEX 'state_index ('V_STATE');
Which clause when added to the end of a statement creates an index
Guru01 - Stuvia
on the customer_id field?
Statement after foreign / primary keyAns: INDEX custid_index
(customer_id));
Which syntax is the correct way to use the DROP INDEX command to
drop a primary key from a table?Ans: DROP INDEX `PRIMARY` ON
tableName;
In order to create a relationship between the Instructor and Course
tables with two separate primary keys, what should be done?Ans:
Create a new column in the Course table for Instructor ID
What is a characteristic of a database that is normalized to be the
second normal form?Ans: There are no values that are dependent on
only part of a composite primary key
