WGU C170 Basic SQL (Latest
Update) Questions & Answers {Grade A}
100% Correct
Which of the following queries will output the table contents when the value of V_CODE
is not equal to 21344? - Correct answer "SELECT P_DESCRIPT, P_INDATE, P_PRICE,
V_CODE FROM PRODUCT WHERE V_CODE <> 21344;"
A(n) ______________ is a logical group of database objects, such as tables and indexes,
that are related to each other. - Correct answer schema
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 and the output is ordered by the price is - Correct
answer "SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME,
,VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT,
VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;"
"In an INSERT command, a user can indicate just the attributes that have required
values by listing the __________________ inside parentheses after the table name." -
Correct answer attribute names
If a user adds a new column to a table that already has rows, the existing rows will
default to a value of _______ for the new column. - Correct answer null
If integer values are relatively small, ________________ must be used instead of INT. -
Correct answer SMALLINT
You can select partial table contents by naming the desired fields and by placing
restrictions on the rows to be included in the output. - Correct answer TRUE
, The ___________ special operator is used to check whether an attribute value is null. -
Correct answer IS NULL
Some RDBMSs, such as Microsoft Access, automatically make the necessary
conversions to eliminate case sensitivity. - Correct answer TRUE
The SQL aggregate function that gives the arithmetic mean for a specific column is
_______ - Correct answer AVG
The CHECK constraint is used to define a condition for the values that the attribute
domain cannot have. - Correct answer FALSE
The special operator used to check whether a subquery returns any rows is
______________ - Correct answer EXISTS
Update) Questions & Answers {Grade A}
100% Correct
Which of the following queries will output the table contents when the value of V_CODE
is not equal to 21344? - Correct answer "SELECT P_DESCRIPT, P_INDATE, P_PRICE,
V_CODE FROM PRODUCT WHERE V_CODE <> 21344;"
A(n) ______________ is a logical group of database objects, such as tables and indexes,
that are related to each other. - Correct answer schema
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 and the output is ordered by the price is - Correct
answer "SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME,
,VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT,
VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;"
"In an INSERT command, a user can indicate just the attributes that have required
values by listing the __________________ inside parentheses after the table name." -
Correct answer attribute names
If a user adds a new column to a table that already has rows, the existing rows will
default to a value of _______ for the new column. - Correct answer null
If integer values are relatively small, ________________ must be used instead of INT. -
Correct answer SMALLINT
You can select partial table contents by naming the desired fields and by placing
restrictions on the rows to be included in the output. - Correct answer TRUE
, The ___________ special operator is used to check whether an attribute value is null. -
Correct answer IS NULL
Some RDBMSs, such as Microsoft Access, automatically make the necessary
conversions to eliminate case sensitivity. - Correct answer TRUE
The SQL aggregate function that gives the arithmetic mean for a specific column is
_______ - Correct answer AVG
The CHECK constraint is used to define a condition for the values that the attribute
domain cannot have. - Correct answer FALSE
The special operator used to check whether a subquery returns any rows is
______________ - Correct answer EXISTS
