WGU C170 Basic SQL Exam Questions with Correct Answers 100% Verified By
Experts|2025/2026 Latest Update
An alias is especially useful when a table must be joined to itself in a(n) ___________________
query. recursive
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
Experts|2025/2026 Latest Update
An alias is especially useful when a table must be joined to itself in a(n) ___________________
query. recursive
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
