WGU C170 Basic SQL Exam
Questions and Answers 100%
PASS
An alias is especially useful when a table must be joined to itself in a(n)
___________________ query.—ANSWER-recursive
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
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law, Copyrighted By Brittie Donald
Questions and Answers 100%
PASS
An alias is especially useful when a table must be joined to itself in a(n)
___________________ query.—ANSWER-recursive
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
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law, Copyrighted By Brittie Donald
