IT Infrastructure & Data Analysis - IT06 Study Set

Database technology can cut through many of the problems created by a(n)

traditional file organization

Duplicate data in multiple data files is: 

data redundancy

What is the software that controls the structure of a database and access to the data? 

database management system

The ________ is the smallest unit of information that can be retrieved from a database. 

field

The DBMS acts as an interface between application programs and: 

the physical data files.

A(n) ______ database stores data in tables that consist of rows and columns.

relational

Which of the following best describes the principle of least privilege? 

User's’ access privileges are limited to the lowest level necessary perform required tasks.

The field ______ defines the maximum number of characters a field can contain. 

size

________ is a property of a field that defines what values the field can legitimately take on. 

Domain

Which of these is NOT a level of the data storage hierarchy? 

dictionary

A file is a collection of  ________. 

records

Collectively, a course number, course title, and course description would be called a: 

record.

Which of the following best describes the function of a primary key?

To uniquely identify each record in a file

MS Access is a:

PC relational DBMS

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

a data mart typically focuses on a single subject area or line of business.