WGU C170 questions with verified answers
1. SELECT SPNAME
2. FROM SALESPERSON
3. WHERE SPNUM=
4. FROM CUSTOMER
5. WHERE CUSTNUM=20900);
What is missing from the subquery at the beginning of line 4? Ans✓✓✓-(SELECT
SPNUM
A database administrator needs to modify an index on the CUSTOMER table
called IDX_NAME because
there are multiple customers with the same name. It has been determined that it
would be desirable to
modify the index to also include the telephone number.
Which command line will modify the IDX_NAME index on the CUSTOMER table to
include both NAME
and TELEPHONE as part of the index? Ans✓✓✓-ALTER INDEX IDX_NAME ON
CUSTOMER(NAME, TELEPHONE);
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? Ans✓✓✓-SELECT YEAR, TITLE FROM
MOVIE GROUP BY YEAR;
, 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? Ans✓✓✓-The restrict delete rule
A database manager plans to create a view of a table and has these two elements:
Ans✓✓✓-The SELECT privilege for every column referred to elsewhere in the
statement
A database manager starts to convert data that has been normalized into a form
that conforms to the
relational model. A simple primary key has been established and all the repeating
groups have been
deleted.
In which form is this data? Ans✓✓✓-Second normal form
A manager deletes the BUILDING_MANAGEMENT row in a DEPARTMENT table.
Deleting the row also
deletes the GARDENING_TEAM and CLEANING_TEAM rows from the referenced
PERSONNEL_TEAMS table.
Which referential-integrity rule is in effect? Ans✓✓✓-The cascade delete rule
A salesperson is authorized to sell many products and a product can be sold by
many salespersons.
Which kind of binary relationship does this scenario describe? Ans✓✓✓-Many-
to-many
ALTER TABLE tbl_name action [, action ] ... ;
1. SELECT SPNAME
2. FROM SALESPERSON
3. WHERE SPNUM=
4. FROM CUSTOMER
5. WHERE CUSTNUM=20900);
What is missing from the subquery at the beginning of line 4? Ans✓✓✓-(SELECT
SPNUM
A database administrator needs to modify an index on the CUSTOMER table
called IDX_NAME because
there are multiple customers with the same name. It has been determined that it
would be desirable to
modify the index to also include the telephone number.
Which command line will modify the IDX_NAME index on the CUSTOMER table to
include both NAME
and TELEPHONE as part of the index? Ans✓✓✓-ALTER INDEX IDX_NAME ON
CUSTOMER(NAME, TELEPHONE);
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? Ans✓✓✓-SELECT YEAR, TITLE FROM
MOVIE GROUP BY YEAR;
, 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? Ans✓✓✓-The restrict delete rule
A database manager plans to create a view of a table and has these two elements:
Ans✓✓✓-The SELECT privilege for every column referred to elsewhere in the
statement
A database manager starts to convert data that has been normalized into a form
that conforms to the
relational model. A simple primary key has been established and all the repeating
groups have been
deleted.
In which form is this data? Ans✓✓✓-Second normal form
A manager deletes the BUILDING_MANAGEMENT row in a DEPARTMENT table.
Deleting the row also
deletes the GARDENING_TEAM and CLEANING_TEAM rows from the referenced
PERSONNEL_TEAMS table.
Which referential-integrity rule is in effect? Ans✓✓✓-The cascade delete rule
A salesperson is authorized to sell many products and a product can be sold by
many salespersons.
Which kind of binary relationship does this scenario describe? Ans✓✓✓-Many-
to-many
ALTER TABLE tbl_name action [, action ] ... ;
