WGU C170 UPDATED ACTUAL EXAM
QUESTIONS AND CORRECT ANSWERS
●● The ___________ condition is generally composed of an equality
comparison between the foreign key and the primary key of related
tables.
Answer: join
●● A database language enables the user to create database and table
structures to perform basic data management chores.
Answer: TRUE
●● ______________________ is the process the DBMS uses to verify
that only registered users access the database.
Answer: Authentication
●● Only numeric data types can be added and subtracted in SQL.
Answer: FALSE
●● A table can be deleted from the database by using the
_______________________ command.
Answer: DROP TABLE
,●● To list all the contents of the PRODUCT table, a user would use
________________________________
Answer: SELECT * FROM PRODUCT
●● All SQL commands must be issued on a single line.
Answer: FALSE
●● Mathematical operators cannot be used to place restrictions on
character-based attributes.
Answer: FALSE
●● A(n) _____________________ is a query that is embedded (or
nested) inside another query.
Answer: 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
________________________________________________
Answer: "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.
Answer: query
●● The SQL aggregate function that gives the total of all values for a
selected attribute in a given column is _______
Answer: SUM
●● String comparisons are made from left to right.
Answer: TRUE
●● Date procedures are often more software-specific than other SQL
procedures.
Answer: TRUE
●● To make the output more readable, the SQL standard permits the use
of aliases for any column in a _____________ statement.
Answer: 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.
Answer: cascading
QUESTIONS AND CORRECT ANSWERS
●● The ___________ condition is generally composed of an equality
comparison between the foreign key and the primary key of related
tables.
Answer: join
●● A database language enables the user to create database and table
structures to perform basic data management chores.
Answer: TRUE
●● ______________________ is the process the DBMS uses to verify
that only registered users access the database.
Answer: Authentication
●● Only numeric data types can be added and subtracted in SQL.
Answer: FALSE
●● A table can be deleted from the database by using the
_______________________ command.
Answer: DROP TABLE
,●● To list all the contents of the PRODUCT table, a user would use
________________________________
Answer: SELECT * FROM PRODUCT
●● All SQL commands must be issued on a single line.
Answer: FALSE
●● Mathematical operators cannot be used to place restrictions on
character-based attributes.
Answer: FALSE
●● A(n) _____________________ is a query that is embedded (or
nested) inside another query.
Answer: 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
________________________________________________
Answer: "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.
Answer: query
●● The SQL aggregate function that gives the total of all values for a
selected attribute in a given column is _______
Answer: SUM
●● String comparisons are made from left to right.
Answer: TRUE
●● Date procedures are often more software-specific than other SQL
procedures.
Answer: TRUE
●● To make the output more readable, the SQL standard permits the use
of aliases for any column in a _____________ statement.
Answer: 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.
Answer: cascading
