IT

Question 1

enterprise resource planning (ERP) systems

Answer 1

The online analytical processing system (OLAP) incorporates data warehouse and data mining capabilities within the ERP.
The online transaction processing system (OLTP) records the day-to-day operational transactions and enhances the visibility of these transactions throughout the system. It is primarily the OLAP and not the OLTP, that provides an integrated view of transactions in all parts of the system. The OLTP is primary concerned with collecting data (and not analyzing it) across the organization.

Question 2

ERP

Answer 2

It is a primary objective of an enterprise resource planning system to integrate data from all aspects of an organization’s activities into a centralized data repository. Hence, this is the best answer to the question.

Question 3

OLAP

Answer 3

On-line analytical processing systems (OLAPs) are an increasingly important multidimensional analytical tool. An OLAP is a modification and expansion of an on-line transaction processing system to provide the capabilities and functionalities identified in this question.

Question 4

In DRP, top priority is given to which activities

Answer 4

mission critical

Question 5

redundancy

Answer 5

This is the best answer since system redundancy is essential to ensuring business continuit

Question 6

Data control clerk

Answer 6

This is the best answer since system redundancy is essential to ensuring business continuit

Question 7

Data conversion happens at this stage

Answer 7

Implimentation (the process of moving from old to new happens at this stage)

Question 8

At this stage, we purchase hardware:

Answer 8

design and development

Question 9

The requirements definition document is signed at this stage

Answer 9

Analysis

Question 10

Change Control

Answer 10

The practice of authorizing changes, approving tests results, and copying developmental programs to a production library is program change control

Question 11

Validity

Answer 11

A validity check compares the value entered in a field to a list of valid data values. An error message is displayed if the value is not found on the list

Question 12

Reasonableness

Answer 12

Reasonableness checks look at the values in two related fields to ensure that they make sense as a unit

Question 13

An audit trail is considered what type of control

Answer 13

Processing

Question 14

Electronic data interchange

Answer 14

Electronic data interchange (EDI) allows companies to place orders with their suppliers electronically. This reduces the costs associated with producing, distributing, and managing the paperwork associated with a traditional ordering system and dramatically reduces the amount of time required to receive and process the order

Question 15

Decision support system

Answer 15

Decision support systems (DSSs) provide information to mid- and upper-level management to assist them in managing non-routine problems and in long-range planning.

Question 16

Data mart

Answer 16

A data mart is more specialized than a data warehouse. The data mart is often constructed to support specific needs of subunits of an organization.

Question 17

Datawarehousing and pattern recognition

Answer 17

A data warehouse is a database archive of an organization’s operational transactions (sales, purchases, production, payroll, etc.) over a period of years; external data that might be correlated with these transactions, such as economic indicators, stock prices, and exchange rates, are also included.
Pattern recognition is a major component of data mining software: data mining is the process of performing statistical analysis and automatically searching for patterns in large volumes of data

Question 18

Flat file system

Answer 18

while flat file systems do contain program independence, this is seen as a disadvantage not an advantage. This is because the program independence of flat file systems means that multiple programs must be used to read, access and process the data. Statement II is incorrect because flat file systems contain a high degree of data redundancy.

Question 19

Data Definition Language

Answer 19

Data definition language (DDL) is used to create tables and fields of information within the fields.

Question 20

Data control language

Answer 20

This answer is correct because data control language is composed of commands used to control a database, including controlling which users have various privileges (e.g., who is able to read from and write to various portions of the database).