WGU C170 EXAM WITH 100% CORRECT AND
VERIFIED ANSWERS
Your answers
1 of 53
Term
Refer to the given SQL statement.
SELECT PRODNUM, SUM(QUANTITY)
FROM SALESPERSON
Which line, when added to the end of the statement, returns the
total number of each kind of product by product number?
SUM PRODNUM;
COUNT PRODNUM;
ORDER BY PRODNUM;
GROUP BY PRODNUM;
An employee number
A meeting code Set-to-Null
, GROUP BY PRODNUM; The restrict delete rule
Don't know?
2 of 53
Definition
SELECT YEAR, TITLE FROM MOVIE GROUP BY YEAR;
A database administrator of a movie rental company needs to compile a
list of movies released each year for a marketing campaign.
Which SQL command will accomplish this?
SELECT MOVIE, YEAR FROM MOVIE BY TITLE;
SELECT MOVIE, TOTAL FROM MOVIE BY TITLE;
SELECT MOVIE, TITLE FROM MOVIE BY MOVIE YEAR;
SELECT YEAR, TITLE FROM MOVIE GROUP BY
YEAR; SELECT YEAR, TOTAL FROM MOVIE ORDER
BY YEAR;
,Refer to the given SQL statement.
SELECT PRODNUM, SUM(QUANTITY)
FROM SALESPERSON
Which line, when added to the end of the statement, returns the total number of
each kind of product by product number?
SUM PRODNUM;
COUNT PRODNUM;
ORDER BY
PRODNUM; GROUP
BY PRODNUM;
A database administrator tries to delete a row in a parent table, but the delete
fails because a row in another table depends on that row.
Which referential-integrity rule is in effect?
The default delete rule
The restrict delete rule
The cascade delete rule
The set-to-null delete rule
Which task does ORDER BY perform by default?
Sorting rows in ascending order
Sorting rows in descending order
Sorting columns in ascending order
Sorting columns in descending order
Don't know?
, 3 of 53
Definition
Every row in the table is updated.
What happens in an UPDATE statement if the WHERE clause is omitted?
Only the first row in the table is updated.
Every column in the table is updated.
Every row in the table is updated.
Returns an error.
What does WHERE identify in a basic SQL SELECT statement?
The associative entity
The rows to be
included A table's
intersection data
A range of included columns
Which syntax is the correct way to use the DROP INDEX command to drop a
primary key from a table?
DROP INDEX PRIMARY KEY tbl_name;
DROP INDEX `PRIMARY` ON tbl_name ;
DROP INDEX `PRIMARY KEY` ON tbl_name;
DROP INDEX WHERE PRIMARY KEY = tbl_name ;
What does the DELETE statement do?
It removes views.
It removes rows from a table.
VERIFIED ANSWERS
Your answers
1 of 53
Term
Refer to the given SQL statement.
SELECT PRODNUM, SUM(QUANTITY)
FROM SALESPERSON
Which line, when added to the end of the statement, returns the
total number of each kind of product by product number?
SUM PRODNUM;
COUNT PRODNUM;
ORDER BY PRODNUM;
GROUP BY PRODNUM;
An employee number
A meeting code Set-to-Null
, GROUP BY PRODNUM; The restrict delete rule
Don't know?
2 of 53
Definition
SELECT YEAR, TITLE FROM MOVIE GROUP BY YEAR;
A database administrator of a movie rental company needs to compile a
list of movies released each year for a marketing campaign.
Which SQL command will accomplish this?
SELECT MOVIE, YEAR FROM MOVIE BY TITLE;
SELECT MOVIE, TOTAL FROM MOVIE BY TITLE;
SELECT MOVIE, TITLE FROM MOVIE BY MOVIE YEAR;
SELECT YEAR, TITLE FROM MOVIE GROUP BY
YEAR; SELECT YEAR, TOTAL FROM MOVIE ORDER
BY YEAR;
,Refer to the given SQL statement.
SELECT PRODNUM, SUM(QUANTITY)
FROM SALESPERSON
Which line, when added to the end of the statement, returns the total number of
each kind of product by product number?
SUM PRODNUM;
COUNT PRODNUM;
ORDER BY
PRODNUM; GROUP
BY PRODNUM;
A database administrator tries to delete a row in a parent table, but the delete
fails because a row in another table depends on that row.
Which referential-integrity rule is in effect?
The default delete rule
The restrict delete rule
The cascade delete rule
The set-to-null delete rule
Which task does ORDER BY perform by default?
Sorting rows in ascending order
Sorting rows in descending order
Sorting columns in ascending order
Sorting columns in descending order
Don't know?
, 3 of 53
Definition
Every row in the table is updated.
What happens in an UPDATE statement if the WHERE clause is omitted?
Only the first row in the table is updated.
Every column in the table is updated.
Every row in the table is updated.
Returns an error.
What does WHERE identify in a basic SQL SELECT statement?
The associative entity
The rows to be
included A table's
intersection data
A range of included columns
Which syntax is the correct way to use the DROP INDEX command to drop a
primary key from a table?
DROP INDEX PRIMARY KEY tbl_name;
DROP INDEX `PRIMARY` ON tbl_name ;
DROP INDEX `PRIMARY KEY` ON tbl_name;
DROP INDEX WHERE PRIMARY KEY = tbl_name ;
What does the DELETE statement do?
It removes views.
It removes rows from a table.
