COMP ITF+ 1003 MODULE 4 EXAM REVIEW
QUESTIONS AND VERIFIED ANSWERS
An employee at your office just got married and changed their last name. Which
command do you use to change their last name in the employee database?
UPDATE
ALTER
EDIT
MODIFY - Answers - update
Oscar's user account has been granted permissions to view a database. Nathan then
uses the deny command in an attempt to deny Oscar the ability to view the database
and applies it to a group to which Oscar belongs. Which of the following statements is
true?
Oscar will no longer be able to view the database, because the deny cancels the grant,
giving Oscar no specific permissions.
Oscar will still be able to view the database because granted permissions must be
removed with the revoke command.
Oscar will no longer be able to view the database because a deny overrides a grant.
Oscar will still be able to view the database because a grant overrides a deny. -
Answers - oscar will no longer be able to view the database because a deny overrides a
grant
You have configured a database in the headquarters office located in Houston, Texas.
Users in Eastern Canada complain about slow query access to the database, while
Texas users enjoy fast performance. What should you do?
Create a foreign key
Place a writable replica in Eastern Canada
Place a read replica in Eastern Canada
Create an Index - Answers - place a read replica in eastern canada
, Kate, a database administrator, needs to add records into a database. Which command
should she use?
CREATE
INSERT
UPDATE
ALTER - Answers - insert
A school has a database with four tables, but it needs a fifth table. Which command is
used to accomplish this task?
INSERT
ALTER
CREATE
UPDATE - Answers - create
Laura, your manager, instructs you to remove a table from a database permanently.
Which command should you use?
DELETE
DROP
REMOVE
ALTER - Answers - drop
Which of the following statements most accurately describes what a primary key refers
to?
record in a table
a table in a schema
a field in a table
a schema in a database - Answers - a field in a table
Rachel, a database administrator, has created a database for her website. It contains
pictures of vacations that people have uploaded. In the database, pictures have
QUESTIONS AND VERIFIED ANSWERS
An employee at your office just got married and changed their last name. Which
command do you use to change their last name in the employee database?
UPDATE
ALTER
EDIT
MODIFY - Answers - update
Oscar's user account has been granted permissions to view a database. Nathan then
uses the deny command in an attempt to deny Oscar the ability to view the database
and applies it to a group to which Oscar belongs. Which of the following statements is
true?
Oscar will no longer be able to view the database, because the deny cancels the grant,
giving Oscar no specific permissions.
Oscar will still be able to view the database because granted permissions must be
removed with the revoke command.
Oscar will no longer be able to view the database because a deny overrides a grant.
Oscar will still be able to view the database because a grant overrides a deny. -
Answers - oscar will no longer be able to view the database because a deny overrides a
grant
You have configured a database in the headquarters office located in Houston, Texas.
Users in Eastern Canada complain about slow query access to the database, while
Texas users enjoy fast performance. What should you do?
Create a foreign key
Place a writable replica in Eastern Canada
Place a read replica in Eastern Canada
Create an Index - Answers - place a read replica in eastern canada
, Kate, a database administrator, needs to add records into a database. Which command
should she use?
CREATE
INSERT
UPDATE
ALTER - Answers - insert
A school has a database with four tables, but it needs a fifth table. Which command is
used to accomplish this task?
INSERT
ALTER
CREATE
UPDATE - Answers - create
Laura, your manager, instructs you to remove a table from a database permanently.
Which command should you use?
DELETE
DROP
REMOVE
ALTER - Answers - drop
Which of the following statements most accurately describes what a primary key refers
to?
record in a table
a table in a schema
a field in a table
a schema in a database - Answers - a field in a table
Rachel, a database administrator, has created a database for her website. It contains
pictures of vacations that people have uploaded. In the database, pictures have
