WGU C170 Basic SQL and Advanced SQL| WITH
COMPLETE SOLUTIONS
An alias is especially useful when a table must be joined to itself in a(n) ___________________
query. Correct Answer: recursive
The ___________ condition is generally composed of an equality comparison between the
foreign key and the primary key of related tables. Correct Answer: join
A database language enables the user to create database and table structures to perform basic
data management chores. Correct Answer: TRUE
______________________ is the process the DBMS uses to verify that only registered users
access the database. Correct Answer: Authentication
Only numeric data types can be added and subtracted in SQL. Correct Answer: FALSE
A table can be deleted from the database by using the _______________________ command.
Correct Answer: DROP TABLE
To list all the contents of the PRODUCT table, a user would use
________________________________ Correct Answer: SELECT * FROM PRODUCT
All SQL commands must be issued on a single line. Correct Answer: FALSE
Mathematical operators cannot be used to place restrictions on character-based attributes. Correct
Answer: FALSE
A(n) _____________________ is a query that is embedded (or nested) inside another query.
Correct 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
________________________________________________ Correct 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. Correct
Answer: query
The SQL aggregate function that gives the total of all values for a selected attribute in a given
column is _______ Correct Answer: SUM
String comparisons are made from left to right. Correct Answer: TRUE
, Date procedures are often more software-specific than other SQL procedures. Correct Answer:
TRUE
To make the output more readable, the SQL standard permits the use of aliases for any column in
a _____________ statement. Correct 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. Correct
Answer: cascading
Data type selection is usually dictated by the nature of the data and by the intended use. Correct
Answer: TRUE
The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07.
Correct Answer: 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. Correct Answer: 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? Correct Answer:
"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. Correct Answer: TRUE
DATE() and SYSDATE are special functions that return today's date in MS Access and
__________________, respectively. Correct Answer: 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? Correct Answer: "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.
Correct Answer: ROLLBACK;
According to the rules of precedence, which of the following computations should be completed
first? Correct Answer: Performing operations within parentheses
Which of the following queries will output the table contents when the value of V_CODE is
equal to 21344? Correct Answer: "SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT WHERE V_CODE = 21344;"
COMPLETE SOLUTIONS
An alias is especially useful when a table must be joined to itself in a(n) ___________________
query. Correct Answer: recursive
The ___________ condition is generally composed of an equality comparison between the
foreign key and the primary key of related tables. Correct Answer: join
A database language enables the user to create database and table structures to perform basic
data management chores. Correct Answer: TRUE
______________________ is the process the DBMS uses to verify that only registered users
access the database. Correct Answer: Authentication
Only numeric data types can be added and subtracted in SQL. Correct Answer: FALSE
A table can be deleted from the database by using the _______________________ command.
Correct Answer: DROP TABLE
To list all the contents of the PRODUCT table, a user would use
________________________________ Correct Answer: SELECT * FROM PRODUCT
All SQL commands must be issued on a single line. Correct Answer: FALSE
Mathematical operators cannot be used to place restrictions on character-based attributes. Correct
Answer: FALSE
A(n) _____________________ is a query that is embedded (or nested) inside another query.
Correct 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
________________________________________________ Correct 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. Correct
Answer: query
The SQL aggregate function that gives the total of all values for a selected attribute in a given
column is _______ Correct Answer: SUM
String comparisons are made from left to right. Correct Answer: TRUE
, Date procedures are often more software-specific than other SQL procedures. Correct Answer:
TRUE
To make the output more readable, the SQL standard permits the use of aliases for any column in
a _____________ statement. Correct 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. Correct
Answer: cascading
Data type selection is usually dictated by the nature of the data and by the intended use. Correct
Answer: TRUE
The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07.
Correct Answer: 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. Correct Answer: 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? Correct Answer:
"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. Correct Answer: TRUE
DATE() and SYSDATE are special functions that return today's date in MS Access and
__________________, respectively. Correct Answer: 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? Correct Answer: "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.
Correct Answer: ROLLBACK;
According to the rules of precedence, which of the following computations should be completed
first? Correct Answer: Performing operations within parentheses
Which of the following queries will output the table contents when the value of V_CODE is
equal to 21344? Correct Answer: "SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT WHERE V_CODE = 21344;"
