Data Management Applications questions with
verified answers
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?
ALTER INDEX IDX_NAME ON CUSTOMER(NAME, TELEPHONE);
MODIFY INDEX IDX_NAME BY CUSTOMER(NAME, TELEPHONE);
CHANGE INDEX IDX_NAME BY CUSTOMER(NAME, TELEPHONE);
REPLACE INDEX IDX_NAME ON CUSTOMER(NAME, TELEPHONE); 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?
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; 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?
The default delete rule
The restrict delete rule
The cascade delete rule
The set-to-null delete rule Ans✓✓✓-The restrict delete rule
A database manager plans to create a view of a table and has these two elements:
• The CREATE VIEW privilege for the table
• A level of privilege for every column selected by the SELECT
What else does the manager need to create this view?
The values created by the syntax INSERT INTO tbl_name VALUES(...),(...),... ;
The SELECT privilege for every column referred to elsewhere in the statement
A reciprocal level of privilege for every row selected by the SELECT statement
, The level of privilege for every column that is part of the base table 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?
First normal form
Second normal form
Third normal form
Fourth normal form 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?
The default delete rule
The restrict delete rule
The cascade delete rule
The set-to-null delete rule Ans✓✓✓-The cascade delete rule
verified answers
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?
ALTER INDEX IDX_NAME ON CUSTOMER(NAME, TELEPHONE);
MODIFY INDEX IDX_NAME BY CUSTOMER(NAME, TELEPHONE);
CHANGE INDEX IDX_NAME BY CUSTOMER(NAME, TELEPHONE);
REPLACE INDEX IDX_NAME ON CUSTOMER(NAME, TELEPHONE); 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?
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; 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?
The default delete rule
The restrict delete rule
The cascade delete rule
The set-to-null delete rule Ans✓✓✓-The restrict delete rule
A database manager plans to create a view of a table and has these two elements:
• The CREATE VIEW privilege for the table
• A level of privilege for every column selected by the SELECT
What else does the manager need to create this view?
The values created by the syntax INSERT INTO tbl_name VALUES(...),(...),... ;
The SELECT privilege for every column referred to elsewhere in the statement
A reciprocal level of privilege for every row selected by the SELECT statement
, The level of privilege for every column that is part of the base table 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?
First normal form
Second normal form
Third normal form
Fourth normal form 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?
The default delete rule
The restrict delete rule
The cascade delete rule
The set-to-null delete rule Ans✓✓✓-The cascade delete rule
