MIS Exam 3

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

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

A__________converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

For each database, there:

In a relational database, every record must be uniquely identified by a__________.

In comparison with a flat file system, _____ in a database.

In data warehouses, _____ is information about data—its content, quality, condition, origin, and other characteristics.

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

In the context of segmentation of customers in database marketing,__________is a variable that includes gender, age, income, and marital status.

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

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

Which of the following is a key factor that has contributed to the growth and popularity of big data?

Which of the following is an advantage of a database over a flat file system?

Which of the following statements is true of big data?

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Each column in an Access table datasheet represents a ____.

Each row in an Access table datasheet displays which of the following?

The specific content of a field is referred to as the ____.

A database or a relational database is a collection of related tables.

Each record in a table is uniquely identified by a foreign key.

Access does not require a table to have a(n) primary key.

All fields in a database should be contained in one table.

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

In order to define table relationships, each table being joined must contain a common field.

A _______ Excel workbook tracks the changes made by different people so everyone can examine when and where each change was made.

Marking a workbook as final makes the workbook _______, discouraging a user from making any changes to it.

_____ is concerned with issues such as political repercussions of using an information system and meeting the requirements of the Information Privacy Act.

_____ is concerned with whether a new system can be completed on time.

_____ uses an iterative process that repeats the design, development, and testing steps as needed, based on feedback from users.

__________are small-scale versions of information systems, which are built before building the entire system, and are used to illustrate the system's benefits and allow users to offer feedback.

During the _____ of the systems development life cycle (SDLC), an information system is operating, enhancements and modifications to the system have been developed and tested, and hardware and software components have been added or replaced.

During the__________of the systems development life cycle (SDLC), a team assesses how a system is working and takes steps to keep the system up and running.

In _____ of the implementation phase of the systems development life cycle (SDLC), as each module of a new system is converted, the corresponding part of an old system is retired.

In _____ of the implementation phase of the systems development life cycle (SDLC), the old and new systems run simultaneously for a short time to ensure the new system works correctly.

In the context of the planning phase of the systems development life cycle (SDLC), which of the following is an example of an internally identified problem in information systems?

In the design phase of the systems development life cycle (SDLC), the _____ indicates hardware and software, such as specifying Linux servers and Windows clients.

The end result of the__________of the systems development life cycle (SDLC) model should give users and top management a clear view of what the problem is and how the information system will solve the problem.

Which of the following is categorized as a tangible benefit of an information system?

One of the advantages of prototyping is that modifying a prototype is easier than modifying a complete system.

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

In a relational database model, a(n) _____ pares down a table by eliminating columns according to certain criteria.

The _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

The variety dimension of big data refers to the combination of _____.

The use of the OR operator in a query form, when using query by example (QBE), means that only one of the conditions must be met.