MIS CH 3

In a(n) _____ access file structure, records can be accessed in any order, regardless of their physical locations in storage media.

• sequential

• random

• indexed

• direct

A _____ is software for creating, storing, maintaining, and accessing database files.

• database management system

• data hierarchical system

• database modelling tool

• data warehousing tool

The advantage of the _____ access method is that both sequential and random access can be used to access records, depending on the number being accessed.

• indexed sequential

• progressive

• direct random

• random-serialized

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

• The indexed sequential access method

• The indexed network access structure

• The indexed random access file structure

• The indexed hierarchical access method

In the context of the types of data in a database, which is a source of internal data?

• Tax records

• Sales records

• Distribution networks

• Economic indicators

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

• data dictionary

• data mine

• data warehouse

• data mart

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

• secondary key

• foreign key

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

• Data structure

• Schema diagrams

• Integrity rules

• File procedure

In a relational database model, which operation searches data in a table and retrieves records based on certain criteria?

• insert operation

• join operation

• find operation

• select operation

In a(n) _____, nodes with the same parents are called twins or siblings.

• hierarchical model

• network model

• relational model

• object-based model