question

Business intelligence uses scorecards and query reports to support decision-making activities, whereas business analytics uses data mining tools and predictive modeling.

answer

True

question

The indexed sequential access method (ISAM) is slow and becomes increasingly useful as the number of records becomes larger.

answer

False, the method is fast and only slows with large numbers of files

question

In a data warehouse, _____ means collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

answer

Extraction

question

In a relational model, when a primary key for one table appears in another table it is called a _____ key.

answer

Foreign

question

A data _____ is usually a smaller version of a data warehouse, used by a single department or function.

answer

mart

question

Business analytics uses _____ to support decision-making activities.

answer

Data Mining Tools

question

The sequential access file structure method is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

answer

True

question

_____ is information in its original form.

answer

Raw data

question

The _____ in a database model defines the boundaries of a database, such as maximum and minimum values allowed for a field.

answer

Set of Integrity Rules

question

To begin designing a relational database, you must define the _____ structure by definig each table and the fields in it.

answer

Logical

question

Redundant data is eliminated by a process called normalization.

answer

True

question

Data redundancy is eliminated or minimized in a flat file system.

answer

False, a flat file system has no hierarchy and no relationship among files

question

The data _____ component is used to add, delete, modify, and retrieve records from a database.

answer

Manipulation

question

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

answer

Normalization

question

A database engine converts logical requests from users into their physical equivalent by interacting with other components of the DBMS.

answer

True

question

The database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

answer

True

question

_____ generally uses internal data and responds in real time.

answer

Online transaction processing

question

The database component of an information system accesses only internal data.

answer

False

question

As compared to data warehouses, consolidating information from different departments or functional areas is easier in data marts.

answer

False, data marts have a more limited scope than data warehouses

question

The network model is similar to the hierarchical model because records are organized in the same way.

answer

False, a record in a network model can have multiple parent and children records where in a hierarchical it can't

question

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods.

answer

True

question

The structure and organization of data in a database is called a data _____.

answer

hierarchy

question

The _____ approach to a distributed DBMS has each site store a copy of the data in the organization's database.

answer

replication

question

The _____ view involves how data is stored on and retrieved from storage media.

answer

physical

question

Sales records are an example of what type of data?

answer

internal data

question

Is the following statement true of a flat file system: More sophisticated security measures cannot be used.

answer

Yes, it is true

question

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

answer

True

question

A select operation pares down a table by eliminating columns according to certain criteria.

answer

False, a project operation does this

question

The data _____ component is used to create and maintain the data dictionary.

answer

Definition

question

An e-commerce site that needs frequent updates would benefit from the use of a static Web site.

answer

False, a data driven website would provide the correct interface

question

A data _____ stores definitions, such as data types for fields, default values, and validation rules for data in each field.

answer

Dictionary

question

Tax records are an example of what type of data?

answer

External data

question

The _____ approach to setting up a distributed DBMS addresses how tables are divided among multiple locations.

answer

Fragmentation

question

A _____ key uniquely identifies every record in a relational database.

answer

Primary

question

The _____ in a database model describes methods, calculations, and so forth that can be performed on data, such as updating and querying data.

answer

set of operation rules

question

Grouping objects along with their attributes and methods into a class is called _____.

answer

encapsulation

question

True or False: More information can be generated from the same data in a database.

answer

True

question

The term CRUD stands for copy, revise, undo, and define.

answer

False, stands for create, read, update, and delete

question

The use of OR operator means that only one of the conditions must be met.

answer

True

question

Flat file organization tends to take up unnecessary storage space.

answer

True, due to redundancy

question

In the _____ model, each record can have multiple parent and child records.

answer

network

question

The "integrity rules" component of a data model defines the boundaries of a database, constraints, and access methods.

answer

True

question

The _____ view involves how information appears to users and how it can be organized and retrieved.

answer

logical

question

A database _____ is responsible for data storage, manipulation, and retrieval.

answer

engine

question

We use the _____ operator when all conditions are required to be met.

answer

AND

question

A _____ operation pares down a table by eliminating columns according to certain criteria.

answer

project

question

In a hierarchical data model, nodes with the same parents are called siblings.

answer

True

question

A _____ operation searches data in a table and retrieves records based on certain criteria.

answer

select

question

Data in a data warehouse can be differentiated from data in a database in that the former _____.

answer

comes from a variety of sources

question

For each database, there can be more than one physical view of data.

answer

False, physical view is how data is stored and retrieved from storage media

question

Used to facilitate and manage transaction oriented applications, such as point of sale, data entry, and retrieval transaction processing. Generally uses internal data and responds in real time.

answer

Online Transaction Processing

Test 1 MIS200 HW 3 Review – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards