Combined: MODMIT1 Quiz 2 Units 4 to 7 + MODMIT1 - Unit 6

Question 1

Multi-module application that helps a company manage the business in an integrated fashion.

Accepted Answer

Enterprise Resource Planning

Question 2

A data mart is

Accepted Answer

a data warehouse created for a single function or department

Question 3

There is more than one conceptual view of the database.

Accepted Answer

False - user views, False - Only one

Question 4

Day-to-day transactions are stored in the operational database.

Accepted Answer

True

Question 5

3rd party solutions with specialized functionality software that can be linked to an ERP system

Accepted Answer

Bolt-on software

Question 6

A computer program transforms a clear message into a coded (ciphertext) form using an algorithm

Accepted Answer

Encryption

Question 7

Controls how individual packets of data are formatted, transmitted, and received

Accepted Answer

TCP/IP

Question 8

The conceptual view which represents the database logically and abstractly.

Accepted Answer

Schema

Question 9

A type of anomaly that can generate conflicting and obsolete database values.

Accepted Answer

Update anomaly

Question 10

Negative operational system symptoms brought about by improperly normalized tables.

Accepted Answer

Anomalies

Question 11

DDL is used to insert special database commands into application programs.

Accepted Answer

False - DML

Question 12

Drill-down capability is an OLAP feature of data mining tools.

Accepted Answer

True

Question 13

Provides controlled access to the database

Accepted Answer

DBMS

Question 14

The electronic processing and transmission of business data

Accepted Answer

E-commerce

Question 15

The deletion anomaly in unnormalized databases is easily detected by users.

Accepted Answer

False

Question 16

A deadlock is a phenomenon that prevents the processing of transactions.

Accepted Answer

True

Question 17

Tables that are free of anomalies

Accepted Answer

third normal form

Question 18

ERP implementation that attempts to switch operations from old legacy systems to the new.

Accepted Answer

Bing Bang

Question 19

How many layers are there in the OSI Protocol ?

Accepted Answer

7

Question 20

Used to connect different types of LANs

Accepted Answer

Gateways

Question 21

A programming language used to define the physical database to the DBMS

Accepted Answer

DDL

Question 22

Most ERPs are based on which network model?

Accepted Answer

client-server

Question 23

A multi-dimensional database often using hundreds of gigabytes or even terabytes of memory

Accepted Answer

Data Warehouse

Question 24

In two-tier architecture, the database and application functions are separated.

Accepted Answer

False

Question 25

Which of the following is usually not part of an ERP’s OLAP applications?

Accepted Answer

Logistics

Question 26

A key feature of REA Model that events occur in pairs

Accepted Answer

Economic duality

Question 27

ERP systems support a smooth and seamless flow of information across organizations.

Accepted Answer

True

Question 28

Business model where the Internet is used to sell and deliver digital products to customers

Accepted Answer

Distribution level

Question 29

The deletion anomaly is the least important of the problems affecting unnormalized databases.

Accepted Answer

False

Question 30

Describes every data element in the database

Accepted Answer

Data dictionary

Question 31

Arrange the OSI Protocol layers

Accepted Answer

Physical, data link, network, transport, session, pres, app

Question 32

Which is not eCommerce?

Accepted Answer

buying of goods and services

Question 33

In a two-tier architecture approach is used primarily for wide area network (WAN) applications.

Accepted Answer

False

Question 34

Service providers host applications for client organizations over a network.

Accepted Answer

SaaS

Question 35

Which of the following is usually not part of an ERP’s core applications?

Accepted Answer

OLAP applications

Question 36

Phenomena that effect changes in resources

Accepted Answer

Event

Question 37

A closed database architecture shares data easily.

Accepted Answer

False

Question 38

The nature of the relationship between two entities

Accepted Answer

Cardinality

Question 39

A common server handles both application and database duties and are used especially in LANS

Accepted Answer

Two-tier model

Question 40

This architecture is typical of large ERP systems that use WANs for connectivity among users.

Accepted Answer

Three-tier Model

Combined: MODMIT1 Quiz 2 Units 4 to 7 + MODMIT1 - Unit 6

Questions 40

Combined: MODMIT1 Quiz 2 Units 4 to 7 + MODMIT1 - Unit 6

Questions 40