WGU C170 Basic SQL
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
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
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
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
