WGU C170 Basic SQL Questions with verified
answers
___________ words are words used by SQL to perform specific functions.
Ans✓✓✓-RESERVED
______________________ is the process the DBMS uses to verify that only
registered users access the database. Ans✓✓✓-Authentication
"In an INSERT command, a user can indicate just the attributes that have required
values by listing the __________________ inside parentheses after the table
name." Ans✓✓✓-attribute names
"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
________________________________________________ Ans✓✓✓-"SELECT
P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM
PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;"
"The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields
from the PRODUCT table in ascending order by P_PRICE is
___________________________________________________"
Ans✓✓✓-"SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT
ORDER BY P_PRICE;"
"The SQL query to output the contents of the EMPLOYEE table sorted by last
name, first name, and initial is
__________________________________________________ Ans✓✓✓-"SELECT
, EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM
EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;"
A common practice is to create a(n) ___________ on any field that is used as a
search key, in comparison operations in a conditional expression, or when a user
wants to list rows in a specific order. Ans✓✓✓-INDEX
A database language enables the user to create database and table structures to
perform basic data management chores. Ans✓✓✓-TRUE
A database language enables the user to perform complex queries designed to
transform the raw data into useful information. Ans✓✓✓-TRUE
A specialty field in mathematics, known as ________________ algebra, is
dedicated to the use of logical operators. Ans✓✓✓-Boolean
A table can be deleted from the database by using the
_______________________ command. Ans✓✓✓-DROP TABLE
A table can be deleted from the database by using the
___________________________ command. Ans✓✓✓-DROP TABLE
A(n) _______ is performed when data are retrieved from more than one table at
a time. Ans✓✓✓-JOIN
A(n) ______________ is a logical group of database objects, such as tables and
indexes, that are related to each other. Ans✓✓✓-schema
answers
___________ words are words used by SQL to perform specific functions.
Ans✓✓✓-RESERVED
______________________ is the process the DBMS uses to verify that only
registered users access the database. Ans✓✓✓-Authentication
"In an INSERT command, a user can indicate just the attributes that have required
values by listing the __________________ inside parentheses after the table
name." Ans✓✓✓-attribute names
"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
________________________________________________ Ans✓✓✓-"SELECT
P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM
PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;"
"The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields
from the PRODUCT table in ascending order by P_PRICE is
___________________________________________________"
Ans✓✓✓-"SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT
ORDER BY P_PRICE;"
"The SQL query to output the contents of the EMPLOYEE table sorted by last
name, first name, and initial is
__________________________________________________ Ans✓✓✓-"SELECT
, EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM
EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;"
A common practice is to create a(n) ___________ on any field that is used as a
search key, in comparison operations in a conditional expression, or when a user
wants to list rows in a specific order. Ans✓✓✓-INDEX
A database language enables the user to create database and table structures to
perform basic data management chores. Ans✓✓✓-TRUE
A database language enables the user to perform complex queries designed to
transform the raw data into useful information. Ans✓✓✓-TRUE
A specialty field in mathematics, known as ________________ algebra, is
dedicated to the use of logical operators. Ans✓✓✓-Boolean
A table can be deleted from the database by using the
_______________________ command. Ans✓✓✓-DROP TABLE
A table can be deleted from the database by using the
___________________________ command. Ans✓✓✓-DROP TABLE
A(n) _______ is performed when data are retrieved from more than one table at
a time. Ans✓✓✓-JOIN
A(n) ______________ is a logical group of database objects, such as tables and
indexes, that are related to each other. Ans✓✓✓-schema
