MCQ CHP8-CIS

Question 1

1.An inventory record contains part number, part name, part color, and part weight. These
individual items are called
a. fields.
b. stored files.
c. bytes.
d. occurrences.

Answer 1

A. Fields

Question 2

.It is appropriate to use a sequential file structure when
a. records are routinely inserted.
b. single records need to be retrieved.
c. records need to be scanned using secondary keys.
d. a large portion of the file will be processed in one operation.

Answer 2

D. A large portion of the file will be processed in one operation

Question 3

Which of the following statements is not true?
a. Indexed random files are dispersed throughout the storage device without regard for
physical proximity with related records.
b. Indexed random files use disk storage space efficiently.
c. Indexed random files are efficient when processing a large portion of a file at one time.
d. Indexed random files are easy to maintain in terms of adding records.

Answer 3

C. Indexed random files are efficient when processing a large portion of a file at one time.

Question 4

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 4

A. Data Sharing

Question 5

.Which statement is not correct? The VSAM structure
a. is used for very large files that need both direct access and batch processing.
b. may use an overflow area for records.
c. provides an exact physical address for each record.
d. is appropriate for files that require few insertions or deletions.

Answer 5

C. provides an exact physical address for each record.

Question 6

Which statement is true about a hashing structure?
a. The same address could be calculated for two records.
b. Storage space is used efficiently.
c. Records cannot be accessed rapidly.
d. A separate index is required.

Answer 6

A. The same address could be calculated for two records.

Question 7

.In a hashing structure,
a. two records can be stored at the same address.
b. pointers are used to indicate the location of all records.
c. pointers are used to indicate the location of a record with the same address as another
record.
d. all locations on the disk are used for record storage.

Answer 7

C. pointers are used to indicate the location of a record with the same address as another
record.

Question 8

.Pointers can be used for all of the following except
a. to locate the subschema address of the record.
b. to locate the physical address of the record.
c. to locate the relative address of the record.
d. to locate the logical key of the record

Answer 8

A. to locate the subschema address of the record.

Question 9

Pointers are used
a. to link records within a file.
b. to link records between files.
c. to identify records stored in overflow.
d. all of the above.

Answer 9

D. all of the above

Question 10

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 10

B. the way to access data is by following a predefined data path

Question 11

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

Answer 11

C. Collision

Question 12

.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 12

C. data is represented on two-dimensional tables

Question 12

.The most serious problem with unnormalized databases is the
a. update anomaly
b. insertion anomaly
c. deletion anomaly
d. none of the above

Answer 12

C. Deletion Anomaly

Question 13

.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 13

D. only one-to-many relationships can be supported

Question 14

.In a relational database
a. the user’s 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 user’s view of the database

Answer 14

B. users perceive that they are manipulating a single table

Question 15

The update anomaly in unnormalized databases
a. occurs because of data redundancy
b. complicates adding records to the database
c. may result in the loss of important data
d. often results in excessive record insertions

Answer 15

A. occurs because of data redundancy

Question 16

The deletion anomaly in unnormalized databases
a. is easily detected by users
b. may result in the loss of important data
c. complicates adding records to the database
d. requires the user to perform excessive updates

Answer 16

B. may result in the loss of important data

Question 17

.Which statement is correct?
a. in a normalized database, data about vendors occur in several locations
b. the accountant is responsible for database normalization
c. in a normalized database, deletion of a key record could result in the destruction of the
audit trail
d. connections between M:M tables are provided by a link table

Answer 17

D. connections between M:M tables are provided by a link table

Question 18

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

Answer 18

C. Sequential

Question 19

Which of the following is a relational algebra function?
a. restrict
b. project
c. join
d. all are relational algebra functions

Answer 19

D. all are relational algebra functions

Question 20

.Entities are
a. nouns that are depicted by rectangles on an entity relationship diagram
b. data that describe the characteristics of properties of resources
c. associations among elements
d. sets of data needed to make a decision

Answer 20

A. nouns that are depicted by rectangles on an entity relationship diagram

Question 21

.A user view
a. presents the physical arrangement of records in a database for a particular user
b. is the logical abstract structure of the database
c. specifies the relationship of data elements in the database
d. defines how a particular user sees the database

Answer 21

D. defines how a particular user sees the database

Question 22

.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 22

B. deadlocks are eliminated

Question 22

A table is in third normal form when it is
a. free of repeating group data
b. free of transitive dependencies
c. free of partial dependencies
d. free of deletion anomalies
e. none of the above

Answer 22

B. free of transitive dependencies

Question 23

Each of the following is a relational algebra function except a. join b. project c. link d. restrict

Answer 23

C. Link

Question 23

A table is in first normal form when it is a. free of repeating group data b. free of transitive dependencies c. free of partial dependencies d. free of update anomalies

Answer 23

A. free of repeating group data

Question 24

.A table is in second normal form when it is a. free of repeating group data b. free of transitive dependencies c. free of partial dependencies d. free of insert anomalies e. none of the above

Answer 24

C. free of partial dependencies

Question 25

Which statement is not true? Embedded audit modules a. can be turned on and off by the auditor. b. reduce operating efficiency. c. may lose their viability in an environment where programs are modified frequently. d. identify transactions to be analyzed using white box tests.

Answer 25

D. identify transactions to be analyzed using white box tests.

Question 26

Generalized audit software packages perform all of the following tasks except a. recalculate data fields b. compare files and identify differences c. stratify statistical samples d. analyze results and form opinions

Answer 26

D. analyze results and form opinions

Question 27

A transitive dependency a. is a database condition that is resolved through special monitoring software. b. is a name given to one of the three anomalies that result from unnormalized database tables. c. can exist only in a table with a composite primary key. d. cannot exist in tables that are normalized at the 2NF level. e.is none of the above.

Answer 27

D. cannot exist in tables that are normalized at the 2NF level. e.is none of the above.