Chapter 4

Question 1

All of the following are basic data management tasks except
a. data deletion
b. data storage
c. data attribution
d. data retrieval

Answer 1

C

Question 2

The task of searching the database to locate a stored record for processing is called
a. data deletion
b. data storage
c. data attribution
d. data retrieval

Answer 2

D

Question 3

Which of the following is not a problem usually associated with the flat-file approach to data
management?
a. data redundancy
b. restricting access to data to the primary user
c. data storage
d. currency of information

Answer 3

B

Question 4

Which characteristic is not associated with the database approach to data management?
a. the ability to process data without the help of a programmer
b. the ability to control access to the data
c. constant production of backups
d. the inability to determine what data is available

Answer 4

D

Question 5

Which characteristic is associated with the database approach to data management?
a. data sharing
b. multiple storage procedures
c. data redundancy
d. excessive storage costs

Answer 5

A

Question 6

The textbook refers to four interrelated components of the database concept. Which of the
following is
not one of the components?
a. the database management system
b. the database administrator
c. the physical database
d. The conceptual database

Answer 6

D

Question 7

Which of the following is not a responsibility of the database management system?
a. provide an interface between the users and the physical database
b. provide security against a natural disaster
c. ensure that the internal schema and external schema are consistent
d. authorize access to portions of the database

Answer 7

C

Question 8

A description of the physical arrangement of records in the database is
a. the internal view
b. the conceptual view
c. the subschema
d. the external view

Answer 8

A

Question 9

Which of the following may provide many distinct views of the database?
a. the schema
b. the internal view
c. the user view
d. the conceptual view

Answer 9

C

Question 10

Users access the database
a. by direct query
b. by developing operating software
c. by constantly interacting with systems programmers
d. all of the above

Answer 10

A

Question 11

The data definition language
a. identifies, for the database management system, the names and relationships of all
data elements, records, and files that comprise the database
b. inserts database commands into application programs to enable standard programs to
interact with and manipulate the database
c. permits users to process data in the database without the need for conventional programs
d. describes every data element in the database

Answer 11

A

Question 12

The data manipulation language
a. defines the database to the database management system
b. transfers data to the buffer area for manipulation
c. enables application programs to interact with and manipulate the database
d. describes every data element in the database

Answer 12

C

Question 13

Which statement is not correct? A query language like SQL
a. is written in a fourth-generation language
b. requires user familiarity with COBOL
c. allows users to retrieve and modify data

d. reduces reliance on programmers

Answer 13

B

Question 14

Which duty is not the responsibility of the database administrator?
a. to develop and maintain the data dictionary
b. to implement security controls
c. to design application programs
d. to design the subschema

Answer 14

C

Question 15

In a hierarchical model
a. links between related records are implicit
b. the way to access data is by following a predefined data path
c. an owner (parent) record may own just one member (child) record
d. a member (child) record may have more than one owner (parent)

Answer 15

B

Question 16

Which term is not associated with the relational database model?
a. tuple
b. attribute
c. collision
d. relation

Answer 16

C

Question 17

In the relational database model
a. relationships are explicit
b. the user perceives that files are linked using pointers
c. data is represented on two-dimensional tables
d. data is represented as a tree structure

Answer 17

C

Question 18

In the relational database model all of the following are true except
a. data is presented to users as tables
b. data can be extracted from specified rows from specified tables
c. a new table can be built by joining two tables
d. only one-to-many relationships can be supported

Answer 18

D

Question 19

In a relational database
a. the users view of the physical database is the same as the physical database
b. users perceive that they are manipulating a single table
c. a virtual table exists in the form of rows and columns of a table stored on the disk
d. a programming language (COBOL) is used to create a users view of the database

Answer 19

B

Question 20

Which of the following is not a common form of conceptual database model?
a. hierarchical
b. network
c. sequential
d. relational

Answer 20

C

Question 21

Which statement is false?
a. The DBMS is special software that is programmed to know which data elements each user
is authorized to access.
b. User programs send requests for data to the DBMS.
c. During processing, the DBMS periodically makes backup copies of the physical database.
d. The DBMS does not control access to the database.

Answer 21

D

Question 22

All of the following are elements of the DBMS which facilitate user access to the database
except
a. query language
b. data access language
c. data manipulation language
d. data definition language

Answer 22

B

Question 23

Which of the following is a level of the database that is defined by the data definition
language?
a. user view
b. schema
c. internal view
d. all are levels or views of the database

Answer 23

D

Question 24

An example of a distributed database is
a. partitioned database
b. centralized database
c. networked database
d. all are examples of distributed databases

Answer 24

A

Question 25

Data currency is preserved in a centralized database by a. partitioning the database b. using a lockout procedure c. replicating the database d. implementing concurrency controls

Answer 25

B

Question 26

Which procedure will prevent two end users from accessing the same data element at the same time? a. data redundancy b. data replication c. data lockout d. none of the above

Answer 26

C

Question 27

The advantages of a partitioned database include all of the following except a. user control is enhanced b. data transmission volume is increased c. response time is improved d. risk of destruction of entire database is reduced

Answer 27

B

Question 28

A replicated database is appropriate when a. there is minimal data sharing among information processing units b. there exists a high degree of data sharing and no primary user c. there is no risk of the deadlock phenomenon d. most data sharing consists of read-write transactions

Answer 28

B

Question 29

What control maintains complete, current, and consistent data at all information processing units? a. deadlock control b. replication control c. concurrency control d. gateway contro

Answer 29

C

Question 30

Data concurrency a. is a security issue in partitioned databases b. is implemented using timestamping c. may result in data lockout d. occurs when a deadlock is triggered

Answer 30

B

Question 31

All of the following are advantages of a partitioned database except a. increased user control by having the data stored locally b. deadlocks are eliminated c. transaction processing response time is improved d. partitioning can reduce losses in case of disaster

Answer 31

B

Question 32

Which backup technique is most appropriate for sequential batch systems? a. grandparent-parent-child approach b. staggered backup approach c. direct backup d. remote site, intermittent backup

Answer 32

A

Question 33

When creating and controlling backups for a sequential batch system, a. the number of backup versions retained depends on the amount of data in the file b. off-site backups are not required c. backup files can never be used for scratch files d. the more significant the data, the greater the number of backup versions

Answer 33

D

Question 34

In a direct access file system a. backups are created using the grandfather-father-son approach b. processing a transaction file against a maser file creates a backup file c. files are backed up immediately before an update run d. if the master file is destroyed, it cannot be reconstructed

Answer 34

C

Question 35

Which of the following is not an access control in a database system? a. antivirus software b. database authorization table c. passwords d. voice prints

Answer 35

A

Question 36

Which of the following is not a basic database backup and recovery feature? a. checkpoint b. backup database c. transaction log d. database authority table

Answer 36

D

Question 37

Audit objectives for the database management system include all of the following except a. verifying that the security group monitors and reports on fault tolerance violations b. confirming that backup procedures are adequate c. ensuring that authorized users access only those files they need to perform their duties d. verifying that unauthorized users cannot access data files

Answer 37

A

Question 38

All of the following tests of controls will provide evidence that access to the data files is limited except a. inspecting biometric controls b. reconciling program version numbers c. comparing job descriptions with access privileges stored in the authority table d. attempting to retrieve unauthorized data via inference queries

Answer 38

B

Question 39

Which of the following is not a test of access controls? a. biometric controls b. encryption controls c. backup controls d. inference controls

Answer 39

C

Question 40

The database attributes that individual users have permission to access are defined in a. operating system. b. user manual. c. database schema. d. user view. e. application listing.

Answer 40

D