C170 WGU/ WGU C170 Exam Data Management
Applications Exam New 2025 Version with Questions
and Answers
What does this syntax allow? ----------- Correct Answer ------------- Changing column types
Dropping indexes
What is the proper command to change a view? ----------- Correct Answer ------------- ALTER VIEW
Which optional clause added to a GRANT statement enables the account to give its own privileges to
other uses? ----------- Correct Answer ------------- WITH GRANT OPTION
What is the correct syntax to create an index to be built on the V_STATE field based on the database
information? ----------- Correct Answer ------------- ALTER TABLE 'Vendor' ADD INDEX 'state_index
('V_STATE');
Which clause when added to the end of a statement creates an index on the customer_id field?
Statement after foreign / primary key ----------- Correct Answer ------------- 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? -
---------- Correct Answer ------------- 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? ----------- Correct Answer ------------- 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? ----------- Correct
Answer ------------- There are no values that are dependent on only part of a composite primary key
What is a characteristic of a database that is normalized to the third normal form? ----------- Correct
Answer ------------- All redundancy has been removed
There are no transitive dependencies
Dependencies that are based on only a part of a composite primary key are called transitive dependencies.
----------- Correct Answer ------------- False
Since a partial dependency can exist only if a table's primary key is composed of several attributes, if a
table in 1NF has a single-attribute primary key, then the table is automatically in 2NF. ----------- Correct
Answer ------------- True
Dependencies based on only a part of a composite primary key are known as _____ dependencies. --------
--- Correct Answer ------------- partial
A table that is in 2NF and contains no transitive dependencies is said to be in _____. ----------- Correct
Answer ------------- Third normal form
, Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE
command sequence ----------- Correct Answer ------------- True
UPDATE syntax ----------- Correct Answer ------------- UPDATE <table>
SET <column> = <value>,
WHERE condition;
If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that
composite key, the attribute (B) is fully functionally dependent on (A). ----------- Correct Answer ----------
--- True
A _________ is any key that uniquely identifies each row ----------- Correct Answer ------------- superkey
A ______ key can be described as a minimal superkey, a superkey without any unnecessary attributes ----
------- Correct Answer ------------- candidate key
Referential _____ dictates that the foreign key must contain values that match the primary key in the
related table, or must contain null. ----------- Correct Answer ------------- integrity
The CUSTOMER tables primary key is CUS_CODE the CUSTOMER primary key column has no null
entries, and all entries are unique.
This is an example of ________ integrity. ----------- Correct Answer ------------- entity
A ______ join links tables by selecting only two rows with common values in their common attribute(s). -
---------- Correct Answer ------------- natural
In which two ways can data redundancy affect managing disk space and calculation speed? -----------
Correct Answer ------------- Additional proccessing time is needed to udate redundant data
Redundant data takes up disk space
With which command can a database admin allow a user named Mary to query the Patient table by
executing SELECT commands on it ----------- Correct Answer ------------- GRANT SELECT ON
PATIENT TO 'Mary' @ 'localhost'
What does the WHERE identify in basic SQL SELECT statement ----------- Correct Answer -------------
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
statement ----------- Correct Answer ------------- 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? -----------
Correct Answer ------------- CREATE TABLE newTableName LIKE tableName INSERT INTO
newTableName SELECT * FROM tableName;
ALTER TABLE tableName action [, action] ...;
An ______ only returns matched records from the tables that are being joined. ----------- Correct Answer -
------------ Inner join
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller johnwachi22. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $28.99. You're not tied to anything after your purchase.