Question 1

Which of the following is characteristic of the indexed-sequential access method?

Accepted Answer

A)  Processing is direct-access; queries are sequential. 
B)  Processing is sequential; queries are handled through an index. 
C)  Processing and queries are both handled through an index. 
D)  Processing and queries are both sequential.

Question 2

________ are one of the fundamental building blocks used to construct databases.

Accepted Answer

The answer of ________ are one of the fundamental building...

Question 3

In an ISAM file organization,the portion of the disk on which the actual records are written is the ________ area.

Accepted Answer

The answer of In an ISAM file organization,the portion of...

Question 4

A widely used method of storing and locating records in a direct-access file is

Accepted Answer

A)  when a record's key field corresponds directly to the coding scheme used by the computer itself. 
B)  to store physical device addresses as a field within a file's records. 
C)  to convert a key to a storage location address using an index. 
D)  to convert a key to a storage location address using a randomizing transformation.

Question 5

Four records have the record structure: EQUIPMENT (EQUIP#,LOCATION). EQUIPMENT (204,1)
EQUIPMENT (204,2)
EQUIPMENT (208,1)
EQUIPMENT (209,1)
When sorting these records,which field is the primary sort key and which field is the secondary sort key?

Accepted Answer

A)  EQUIPMENT is primary; no secondary sort key is required. 
B)  EQUIP# is primary; no secondary sort key is required. 
C)  EQUIP# is primary; LOCATION is the secondary key. 
D)  LOCATION is primary; EQUIP# is the secondary key.

Question 6

Overflow in a directly-accessed file means

Accepted Answer

A)  hashing a record to an address. 
B)  vacant storage space created by the hashing results. 
C)  extra storage space is required because the hashing results in more than one record being assigned to the same address. 
D)  a separate section of the disk is allocated for file additions.

Question 7

Database drivers,NOT database connectors,can be used to connect the business application to the DBMS.

Accepted Answer

A) True 
 B)False

Question 8

A trailer record is an extension of a(n)

Accepted Answer

A)  master record. 
B)  attribute. 
C)  segment. 
D)  transaction record.

Question 9

A database alias can also arise because the same data item is called different things in different programs written in different languages.

Accepted Answer

A) True 
 B)False

Question 10

In practice,________ databases outperform ________ databases in a wide range of common tasks that are typically performed in a business environment.

Accepted Answer

A)  object-oriented, relational 
B)  conceptual, relational 
C)  relational, object-oriented 
D)  object-oriented, conceptual

Question 11

A database ________ is a collection of all data item names in a database,along with a description of the standardized representation form of the data items.

Accepted Answer

The answer of A database ________ is a collection of...

Question 12

Describe the duties of the database administrator (DBA)regarding the data dictionary.

Accepted Answer

The answer of Describe the duties of the database administrator...

Question 13

A field would be composed of "customer name" and "customer account number."

Accepted Answer

A) True 
 B)False

Question 14

In a database management system,defining an individual user view of the database is known as defining the

Accepted Answer

A)  subschema. 
B)  name of a data element. 
C)  schema. 
D)  number of positions of the data element.

Question 15

In the entity-relationship model,a diamond shape in a diagram represents

Accepted Answer

A)  a relationship. 
B)  an entity. 
C)  an attribute. 
D)  an object.

Question 16

Variable-length records have characteristics that are not found in fixed-length records.An example of such a characteristic is

Accepted Answer

A)  the field width can be adjusted for each data occurrence. 
B)  because of their size, most records stored on DASD are variable-length records. 
C)  the actual number of fields can vary from one data occurrence to another. 
D)  the field width can be adjusted for each data occurrence and the actual number of fields can vary from one data occurrence to another.

Question 17

The processing and inquiry objectives of file usage are both addressed by

Accepted Answer

A)  sequential-access file organization. 
B)  fully inverted index file organization. 
C)  indexed-sequential file organization. 
D)  direct-access file organization.

Question 18

________ permit(s)the data to be physically stored apart from the application which facilitates a client-server,tiered architecture environment,in which multiple client users access a shared database.

Accepted Answer

A)  Database objects 
B)  Database agnosticity 
C)  Database management system 
D)  Database logical structure

Question 19

The difference between segments and simple records is that

Accepted Answer

A)  simple records have parents and children. 
B)  segment are collections of fields. 
C)  segments have parents and children. 
D)  segments have no fields.

Question 20

A database together with database software is database agnosticity.

Accepted Answer

A) True 
 B)False

Exam 13: Data Management Concepts

Which of the following is characteristic of the indexed-sequential access method?

________ are one of the fundamental building blocks used to construct databases.

In an ISAM file organization,the portion of the disk on which the actual records are written is the ________ area.

A widely used method of storing and locating records in a direct-access file is

Four records have the record structure: EQUIPMENT (EQUIP#,LOCATION) . EQUIPMENT (204,1) EQUIPMENT (204,2) EQUIPMENT (208,1) EQUIPMENT (209,1) When sorting these records,which field is the primary sort key and which field is the secondary sort key?

Overflow in a directly-accessed file means

Database drivers,NOT database connectors,can be used to connect the business application to the DBMS.

A trailer record is an extension of a(n)

A database alias can also arise because the same data item is called different things in different programs written in different languages.

In practice, databases outperform databases in a wide range of common tasks that are typically performed in a business environment.

A database ________ is a collection of all data item names in a database,along with a description of the standardized representation form of the data items.

Describe the duties of the database administrator (DBA)regarding the data dictionary.

A field would be composed of "customer name" and "customer account number."

In a database management system,defining an individual user view of the database is known as defining the

In the entity-relationship model,a diamond shape in a diagram represents

Variable-length records have characteristics that are not found in fixed-length records.An example of such a characteristic is

The processing and inquiry objectives of file usage are both addressed by

________ permit(s) the data to be physically stored apart from the application which facilitates a client-server,tiered architecture environment,in which multiple client users access a shared database.

The difference between segments and simple records is that

A database together with database software is database agnosticity.