Chapter 8: Database Administration
1. In most cases, access to every table and field in a database is a necessity for every user.
a.
True
b.
False
False
1
254
2. The CEO of the company determines the database access privileges for all users.
a.
True
b.
False
False
1
3. Damage to a database can occur through a physical incident such as an abnormally terminated program.
a.
True
b.
False
4. The DBA creates security policies and procedures.
a.
True
b.
False
False
1
257
5. Management approval is not required before the security policies and procedures can be implemented.
a.
True
b.
False
False
1
257
6. To implement and enforce security, the DBA uses such features as encryption and views.
a.
True
b.
False
7. Programmers monitor database usage to detect potential security violations.
a.
True
b.
False
Chapter 8: Database Administration
False
1
257
8. To protect an organization’s data against physical damage, the DBA creates a disaster recovery plan.
a.
True
b.
False
9. The DBA is responsible for DBMS maintenance, data dictionary management, and training.
a.
True
b.
False
10. When a company decides to purchase a new DBMS, the CEO leads the DBMS evaluation and selection
effort.
a.
True
b.
False
False
1
260
11. SQL is an example of a nonprocedural language.
a.
True
b.
False
False
1
262
12. QBE is an example of a procedural language.
a.
True
b.
False
False
1
262
13. A shared lock permits other users to read the data in the database.
a.
True
b.
False
14. An internal company network that uses software tools typically used on the Internet and World Wide Web is
called an extranet.
a.
True
b.
False
False
1
264
15. Another term for production system is the test system.
a.
True
b.
False
False
1
265
16. The ____ determines the access privileges for all users and enters the appropriate authorization rules in the DBMS
catalog to ensure that users access the database only in ways in which they are entitled to do so.
a.
CEO
b.
programmer
c.
DBA
d.
IT manager
1
256
17. A ____ is a place where a record of certain corporate data is kept.
a.
depository
b.
data archive
c.
storage
d.
data bank
b
1
259
18. Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or
can it contain more content, such as information about programs and the various data items these programs access?
a.
Backup and recovery
b.
Data dictionary
c.
Security
d.
Integrity
b
1
262
262
Chapter 8: Database Administration
19. Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may
be locked and are exclusive locks the only ones permitted?
a.
Concurrent update
b.
Data recovery
c.
Data dictionary
d.
Security
1
262
20. ____ locks forbid any other user from accessing the data in any way.
a.
Shared
b.
Exclusive
c.
Limited
d.
Concurrent
b
1
262
21. Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow
partial copies and how does the DBMS handle updates to the same data from two or more replicas?
a.
Backup and recovery
b.
Security
c.
Integrity
d.
Replication and distributed databases
d
1
263
22. Which of the following DBMS evaluation categories does the following question relate to: How many files can you
open at the same time?
a.
Concurrent update
b.
Security
c.
Integrity
d.
Limitations
d
1
263
23. Which of the following DBMS evaluation categories does the following question relate to: On what operating system
and hardware is the DBMS supported?
a.
Concurrent update
b.
Security
c.
Limitations
d.
Limitations
Chapter 8: Database Administration
d
1
263
24. Which of the following DBMS evaluation categories does the following question relate to: What types of files can you
import or export?
a.
Cost
b.
Future plans
c.
Portability
d.
Performance
1
263
25. Which of the following DBMS evaluation categories does the following question relate to: Does the vendor of the
DBMS supply printed or online training manuals and how good are the manuals?
a.
Portability
b.
Performance
c.
Cost
d.
Documentation and training
d
1
263
26. ____ integrity is the constraint that says that the values in foreign keys must match values already in the database.
a.
Parallel
b.
Relational
c.
Conditional
d.
Referential
d
1
263
27. After the DBMS is purchased, the ____ has primary responsibility for installation and maintenance.
a.
IT manager
b.
DBA
c.
CEO
d.
user
b
1
265
28. The ____ establishes the naming conventions for tables, fields, and indexes in the data dictionary.
a.
users
b.
DBMS
Chapter 8: Database Administration
c.
DBA
d.
programmers
1
264
29. The ____ is responsible for providing training in the use of the DBMS.
a.
programmer
b.
analyst
c.
DBA
d.
CEO
1
265
30. After the database designers complete the information-level design, the DBA does the ____-level design.
a.
physical
b.
information
c.
logical
d.
graphical
1
265
31. In order to develop new programs, the programmers need access to the information in the DBMS. They are given
access to the ____.
a.
production system
b.
test system
c.
live system
d.
documentation system
b
1
265
32. Changing the database design to improve the performance is called ____.
a.
tending the design
b.
focusing the design
c.
tuning the design
d.
modifying the design
1
266
33. By default, Access and other DBMSs create indexes automatically for the ____ keys.
a.
primary and minor
Chapter 8: Database Administration
b.
alternate and foreign
c.
secondary and alternate
d.
primary and foreign
d
1
266
34. Tables with indexes allow faster searches, but slow performance on ____.
a.
insertions
b.
deletions
c.
updates
d.
selects
1
266
35. ____ converts a table that is in third normal form to a table no longer in third normal form.
a.
Conversion
b.
Denormalization
c.
Normalization
d.
Replication
b
1
36. ____________________ is the prevention of unauthorized access, either intentional or accidental, to a
database.
Security
1
256
37. If a DBMS lacks essential security features, the _________________________ might create or purchase special
security programs that provide the missing features.
1
257
38. The ____________________ recovery plan specifies the ongoing and emergency actions and procedures
required to ensure data availability if a disaster occurs.
1
259
Chapter 8: Database Administration
39. A(n) ____________________ site is a backup site that is equipped with duplicate hardware and software but
not data.
40. Copies of archival files and database backups should be stored ____________________-site.
41. When the primary key cannot be null, this is known as ____________________.
42. A configuration of several computers connected together that allow users to share a variety of hardware and
software resources is known as a(n) _________________________.
43. ____________________ help means that if a user is having trouble and asks for help, the DBMS will
provide assistance for the particular feature being used at the time the user asks for help.
44. The _________________________ strictly controls the production system.
45. The hardware, software, and database for the users is called the ____________________ system.
46. What is the DBA’s role with regard to access privileges?
47. Discuss the steps that organizations take to protect their data against hard drive failures and electrical power
interruptions or outages.
48. What is a hot site?
49. With just two exceptions, the DBA grants access and update privileges to the production system only to
authorized users. What are the exceptions?
50. What can the DBA do if the organization has no additional money for its production system but needs
further performance improvements?