Chapter 7: Database Administration
Cengage Learning Testing, Powered by Cognero
Page 1
1. Most database management systems support the creation of views.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
191
2. A view is a derived table.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
191
3. Views provide data validation.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
4. Views furnish a certain amount of security; if users are accessing the database through a view, they cannot access any
data that is not included in the view.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
198
5. The existing, permanent tables in a relational database are called stable tables.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
6. To create a view definition, use the DEFINE VIEW command.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
7. To create a view in Access, create a query to define the view and then save the query object in the database.
a.
True
b.
False
Chapter 7: Database Administration
Cengage Learning Testing, Powered by Cognero
Page 2
ANSWER:
True
POINTS:
1
REFERENCES:
192
8. When you create a query that involves a view, the DBMS changes the query to one that selects data from the table(s) in
the database that created the view.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
193
9. When you create a view, you cannot assign column names that are different from those in the base table.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
10. A view can join two or more tables.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
195
11. A view cannot involve statistics.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
12. The defining query can be any transaction.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
13. If the database structure changes, the user cannot access and use the view.
a.
True
b.
False
ANSWER:
POINTS:
Cengage Learning Testing, Powered by Cognero
Page 4
20. You can add rows to a view that includes calculations.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
21. Access does not support the DROP VIEW command.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
203
22. Normally, when the database administrator grants a particular privilege to a user, the user cannot pass that privilege
along to other users.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
203
23. The GRANT command to indicate that a user has all privileges includes the FULL privilege.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
24. The clause WITH GRANT OPTION is meaningful as part of a REVOKE command.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
25. You can create and maintain an index for any row in any table.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
26. An index makes certain types of retrieval more efficient.
a.
True
b.
False
Chapter 7: Database Administration
Cengage Learning Testing, Powered by Cognero
Page 5
ANSWER:
True
POINTS:
1
REFERENCES:
209
27. When users create, alter, or drop tables or create or drop indexes, the DBMS updates the system catalog automatically.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
214
28. An auxiliary key is a column in one table whose values match the primary key in another table.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
29. When the primary key contains more than one column, use commas to separate the column names.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
215
30. You can only specify a primary key when you first create a table.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
31. When you specify a foreign key, the table containing the foreign key is the parent
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
32. You use the LEGAL clause of the ALTER TABLE command to ensure that only legal values satisfying a particular
condition are allowed in a given column.
a.
True
b.
False
ANSWER:
POINTS:
Chapter 7: Database Administration
Cengage Learning Testing, Powered by Cognero
Page 8
d.
IN
ANSWER:
b
POINTS:
1
REFERENCES:
205
43. When you specify a foreign key, the table referenced by the foreign key is the ____.
a.
super
b.
sibling
c.
parent
d.
child
ANSWER:
c
POINTS:
1
REFERENCES:
217
44. The privilege ____ can be granted to change data.
a.
WRITE
b.
UPDATE
c.
ALTER
d.
READ AND WRITE
ANSWER:
b
POINTS:
1
REFERENCES:
205
45. The privilege ____ can be granted to change the table structure.
a.
WRITE
b.
UPDATE
c.
ALTER
d.
MODIFY
ANSWER:
c
POINTS:
1
REFERENCES:
206
46. The database administrator uses the ____ command to revoke privileges from users.
a.
DROP
b.
REMOVE
c.
REVOKE
d.
CANCEL
ANSWER:
c
POINTS:
1
REFERENCES:
206
47. Which of the following commands deletes an index?
a.
DELETE INDEX
b.
REMOVE INDEX
c.
UNINDEX
Chapter 7: Database Administration
Cengage Learning Testing, Powered by Cognero
Page 9
d.
DROP INDEX
ANSWER:
d
POINTS:
1
REFERENCES:
212
48. To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index.
a.
CREATE UNIQUE INDEX
b.
CREATE NONPRIMARY INDEX
c.
CREATE INDEX
d.
CREATE ONLY INDEX
ANSWER:
a
POINTS:
1
REFERENCES:
211
49. The system catalog is also called the ____.
a.
system database
b.
data dictionary
c.
master data table
d.
transaction database
ANSWER:
b
POINTS:
1
REFERENCES:
212
50. In Oracle, the ____ table contains information about the columns within tables.
a.
SYSCOLUMNS
b.
DBA_TAB_COLUMNS
c.
COLUMNS
d.
SHOW_COLUMNS
ANSWER:
b
POINTS:
1
REFERENCES:
212
51. In Oracle, the ____ table contains information about the tables known to SQL.
a.
DBA_TABLES
b.
SHOW_TABLES
c.
ALL_TABLES
d.
SP_TABLES
ANSWER:
a
POINTS:
1
REFERENCES:
212
52. The types of constraints supported in SQL are ____.
a.
primary keys
b.
foreign keys
c.
legal values
Chapter 7: Database Administration
Cengage Learning Testing, Powered by Cognero
Page 10
d.
All of the above
ANSWER:
d
POINTS:
1
REFERENCES:
215
53. The process of managing a database is called database ____________________.
ANSWER:
administration
POINTS:
1
REFERENCES:
191
54. A(n) ____________________ is an application program’s or an individual user’s picture of the database.
ANSWER:
view
POINTS:
1
REFERENCES:
191
55. A view is defined by creating a defining ____________________, which indicates the rows and columns to include in
the view.
ANSWER:
query
POINTS:
1
REFERENCES:
192
56. To create a view definition, use the ____________________ command.
ANSWER:
CREATE VIEW
POINTS:
1
REFERENCES:
192
57. A(n) ____________________ subset view consists of a subset of the rows and columns in some base table.
ANSWER:
row-and-column
POINTS:
1
REFERENCES:
195
58. In general, views that involve joins of ____________________ tables can cause problems at update.
ANSWER:
base
POINTS:
1
REFERENCES:
200
59. When a view is no longer needed, you can remove it using the ____________________ command.
ANSWER:
DROP VIEW
POINTS:
1
REFERENCES:
203
60. ____________________ is the prevention of unauthorized access to a database.
ANSWER:
Security
POINTS:
1
REFERENCES:
204
Cengage Learning Testing, Powered by Cognero
Page 11
61. The main mechanism for providing access to a database is the ____________________ command.
ANSWER:
GRANT
POINTS:
1
REFERENCES:
206
62. The GRANT command to indicate that all users can retrieve data using a SELECT command includes the word
____________________ rather than the specific name of a user.
ANSWER:
PUBLIC
POINTS:
1
REFERENCES:
206
63. If the user needs to be able to pass the privilege to other users, the GRANT command must include the
____________________ clause.
ANSWER:
WITH GRANT OPTION
POINTS:
1
REFERENCES:
206
64. The database administrator uses the ____________________ command to revoke privileges from users.
ANSWER:
REVOKE
POINTS:
1
REFERENCES:
207
65. In a DBMS, the main mechanism for increasing the efficiency with which data is retrieved from the database is the
____________________.
ANSWER:
index
POINTS:
1
REFERENCES:
207
66. You can create and use a(n) ____________________ to speed up the searching process significantly.
ANSWER:
index
POINTS:
1
REFERENCES:
207
67. The command used to create an index is ____________________.
ANSWER:
CREATE INDEX
POINTS:
1
REFERENCES:
210
68. The command used to delete an index is ____________________.
ANSWER:
DROP INDEX
POINTS:
1
REFERENCES:
210
69. To ensure the uniqueness of values in a non-primary key column, you can create a unique index by using the
____________________ command.
ANSWER:
CREATE UNIQUE INDEX
POINTS:
1