100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
C170 WGU/ WGU C170 Exam Data Management Applications Exam New 2025 Version with Questions and Answers $28.99   Add to cart

Exam (elaborations)

C170 WGU/ WGU C170 Exam Data Management Applications Exam New 2025 Version with Questions and Answers

 3 views  0 purchase
  • Course
  • C170 WGU
  • Institution
  • C170 WGU

C170 WGU/ WGU C170 Exam Data Management Applications Exam New 2025 Version with Questions and Answers

Preview 2 out of 9  pages

  • September 27, 2024
  • 9
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • c170 wgu wgu c170 exam
  • C170 WGU
  • C170 WGU
avatar-seller
johnwachi22
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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

80364 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$28.99
  • (0)
  Add to cart