WGU C170 - Data Management - Applications (Latest 2026) Trusted Questions and 100% correct Answers Set (guaranteed pass)

WGU C170 - Data Management - Applications
(Latest 2026) Trusted Questions and 100%
correct Answers Set (guaranteed pass)

• The ___________ condition is generally composed of an equality comparison between
the foreign key and the primary key of related tables. -✓✓join

• A database language enables the user to create database and table structures to
perform basic data management chores. -✓✓TRUE

• ______________________ is the process the DBMS uses to verify that only
registered users access the database. -✓✓Authentication

• Only numeric data types can be added and subtracted in SQL. -✓✓FALSE

• A table can be deleted from the database by using the _______________________
command. -✓✓DROP TABLE

• To list all the contents of the PRODUCT table, a user would use
________________________________ -✓✓SELECT * FROM PRODUCT

• All SQL commands must be issued on a single line. -✓✓FALSE

• Mathematical operators cannot be used to place restrictions on character-based
attributes. -✓✓FALSE

• A(n) _____________________ is a query that is embedded (or nested) inside another
query. -✓✓subquery

• "The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table
and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the
VENDOR table where the values of V_CODE match is
________________________________________________ -✓✓"SELECT
P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM
PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;"

• In the SQL environment, the word ___________ covers both questions and actions. -
✓✓query

, • The SQL aggregate function that gives the total of all values for a selected attribute in
a given column is _______ -✓✓SUM

• String comparisons are made from left to right. -✓✓TRUE

• Date procedures are often more software-specific than other SQL procedures. -
✓✓TRUE

• To make the output more readable, the SQL standard permits the use of aliases for
any column in a _____________ statement. -✓✓SELECT

• A(n) _________________ order sequence is a multilevel ordered sequence that can
be created easily by listing several attributes, separated by commas, after the ORDER
BY clause. -✓✓cascading

• Data type selection is usually dictated by the nature of the data and by the intended
use. -✓✓TRUE

• The ANSI prescribes a standard SQL-the current fully approved version is known as
SQL 07. -✓✓FALSE

• The COUNT function is designed to tally the number of non-null "values" of an
attribute, and is often used in conjunction with the DISTINCT clause. -✓✓TRUE

• Which of the following queries will use the given columns and column aliases from the
PRODUCT table to determine the total value of inventory held on hand? -✓✓"SELECT
P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT;"

• A database language enables the user to perform complex queries designed to
transform the raw data into useful information. -✓✓TRUE

• DATE() and SYSDATE are special functions that return today's date in MS Access
and __________________, respectively. -✓✓Oracle

• Which of the following queries will output the table contents when the value of the
character field P_CODE is alphabetically less than 1558-QW1? -✓✓"SELECT P_CODE,
P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE
<'1558-QW1';"

• The ____________________ command is used to restore the database to its previous
condition. -✓✓ROLLBACK;

• According to the rules of precedence, which of the following computations should be
completed first? -✓✓Performing operations within parentheses