WGU C170 Fundamentals of SQL
Indispensable Study Assessment Guide Exam
Questions with all Questions Accurately
Answered Updated 2024/2025
Most SQL implementations yield case-insensitive searches. - correct answer FALSE
The .....................__ constraint assigns a value to an attribute when a new row is added
to a table. - correct answer DEFAULT
The SQL data manipulation command
HAVING: ....................................................................................__________. - correct
answer restricts the selection of grouped rows based on a condition.
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE
clause. - correct answer TRUE
The basic SQL vocabulary has fewer than ______ words. - correct answer 100
The special operator used to check whether an attribute value is within a range of
values is ....................._ - correct answer BETWEEN
"The SQL query to output the contents of the EMPLOYEE table sorted by last name,
first name, and initial is ..........................................______.......................- correct
answer "SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME,
EMP_INITIAL;"
In a 1:M relationship, a user must always create the table for the ___ side first. - correct
answer 1
, A table can be deleted from the database by using the _____.......................command. -
correct answer DROP TABLE
Which of the following queries will list all the rows in which the inventory stock dates
occur on or after January 20, 2010? - correct answer "SELECT P_DESCRIPT,
P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-
JAN-2010';"
To remove a row from the PRODUCT table, one must use the ..................command. -
correct answer DELETE
When a user issues the DELETE FROM tablename command without specifying a
WHERE condition, ..........................................____. - correct answer all rows will be
deleted
Although SQL commands can be grouped together on a single line, complex command
sequences are best shown on separate lines, with space between the SQL command
and the command's components. - correct answer TRUE
When joining three or more tables, you need to specify a join condition for one pair of
tables. - correct answer FALSE
An alias cannot be used when a table is required to be joined to itself in a recursive
query. - correct answer FALSE
The SQL command that allows a user to list the contents of a table is .....................__. -
correct answer SELECT
The SQL aggregate function that gives the number of rows containing non-null values
for a given column is .....................___. - correct answer COUNT
Indispensable Study Assessment Guide Exam
Questions with all Questions Accurately
Answered Updated 2024/2025
Most SQL implementations yield case-insensitive searches. - correct answer FALSE
The .....................__ constraint assigns a value to an attribute when a new row is added
to a table. - correct answer DEFAULT
The SQL data manipulation command
HAVING: ....................................................................................__________. - correct
answer restricts the selection of grouped rows based on a condition.
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE
clause. - correct answer TRUE
The basic SQL vocabulary has fewer than ______ words. - correct answer 100
The special operator used to check whether an attribute value is within a range of
values is ....................._ - correct answer BETWEEN
"The SQL query to output the contents of the EMPLOYEE table sorted by last name,
first name, and initial is ..........................................______.......................- correct
answer "SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME,
EMP_INITIAL;"
In a 1:M relationship, a user must always create the table for the ___ side first. - correct
answer 1
, A table can be deleted from the database by using the _____.......................command. -
correct answer DROP TABLE
Which of the following queries will list all the rows in which the inventory stock dates
occur on or after January 20, 2010? - correct answer "SELECT P_DESCRIPT,
P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-
JAN-2010';"
To remove a row from the PRODUCT table, one must use the ..................command. -
correct answer DELETE
When a user issues the DELETE FROM tablename command without specifying a
WHERE condition, ..........................................____. - correct answer all rows will be
deleted
Although SQL commands can be grouped together on a single line, complex command
sequences are best shown on separate lines, with space between the SQL command
and the command's components. - correct answer TRUE
When joining three or more tables, you need to specify a join condition for one pair of
tables. - correct answer FALSE
An alias cannot be used when a table is required to be joined to itself in a recursive
query. - correct answer FALSE
The SQL command that allows a user to list the contents of a table is .....................__. -
correct answer SELECT
The SQL aggregate function that gives the number of rows containing non-null values
for a given column is .....................___. - correct answer COUNT
