Exam 8: Data Structures and CAATTs for Data Extraction

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

When a large portion of the file is to be processed in one operation such as payroll,sequential data structures are an inefficient method of organizing a file.

(True/False)
4.8/5
(91)

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

(Essay)
4.9/5
(67)

In a hashing structure,

(Multiple Choice)
4.8/5
(83)

A user view

(Multiple Choice)
4.9/5
(81)

Explain the basic results that come from the restrict,project,and join functions.

(Essay)
4.8/5
(63)

A table is in second normal form when it is

(Multiple Choice)
4.8/5
(81)

VSAM file structures are most effective where rapid access to individual records is a priority need.

(True/False)
4.7/5
(78)

The two fundamental components of data structures are organization and access method.

(True/False)
4.8/5
(82)

The hierarchical database model forces users to navigate between data elements using predefined structured paths.

(True/False)
4.9/5
(72)

What is repeating group data?

(Essay)
5.0/5
(78)

What is the update anomaly?

(Essay)
4.9/5
(83)

The database approach to data management is sometimes called the flat file approach.

(True/False)
4.7/5
(90)

What are the two fundamental components of data structures?

(Short Answer)
4.7/5
(94)

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

(True/False)
4.9/5
(80)

What are the characteristics of a properly designed relational database table?

(Essay)
4.8/5
(89)

What is an embedded audit module?

(Essay)
4.9/5
(81)

Pointers are used

(Multiple Choice)
5.0/5
(68)

Explain the three types of anomalies associated with database tables that have not been normalized.

(Essay)
4.8/5
(64)

A network model does not allow children files to have multiple parent files.

(True/False)
4.9/5
(74)

The physical database is an abstract representation of the database.

(True/False)
4.9/5
(78)
Showing 61 - 80 of 89
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)