Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

FINAL EXAM - Info Mgt 2022

Total questions: 50

Worksheet time: 38mins

Name
Class
Date
1.

What is the organized collection of logically related data?

a)

Database

b)

Information

c)

Metadata

2.

What are stored representations of meaningful objects and events?

a)

Information

b)

Database

c)

Data

3.

Which of these is processed data to increase knowledge in the person using the data?

a)

Database

b)

Information

c)

Metadata

4.

What is the data that describes the properties and context of the user data?

a)

Information

b)

Database

c)

Metadata

5.

The process to turn data into useful information that managers can use for decision making and interpretation.

a)

Graphical Display

b)

Graphics

c)

Charts

6.

Point of which different system/programs have separate copies of the same data

a)

Repeatable

b)

Dataredundancy

c)

Duplication

7.

An attribute combination of attributes that uniquely identify individual instances of an entity

a)

Primary Key

b)

Foreign Key

c)

Identifier

8.

Which relationship is modeled as lines between?

a)

Relationship

b)

Relation Type

c)

Cardinality

9.

What is the combination of relationship and entity?

a)

Associative Entity

b)

Associative Attribute

c)

Associative Cluster

10.

What entity in the relationship will have exactly one related entity?

a)

Mandatory One

b)

Many to Many

c)

Optional One

11.

An entity on one side of the relationship can have many related entities, but an entity on the other side will have a maximum of one related entity.

a)

One to Many

b)

Many to Many

c)

Mandatory Many

12.

Entities on both sides of the relationship can have many related entities on the other side are:

a)

Optional Many

b)

Many to Many

c)

Mandatory Many

13.

Which identifiers underlined with a single line

a)

Strong Entity

b)

Weak Entity

c)

Associate Entity

14.

What is the other term for a partial identifier that underlined with double line?

a)

Weak Entity

b)

Strong Entity

c)

Associative Entity

15.

Iterative process breaking system description into finer and finer detail is a __________

a)

Functional Decomposed

b)

Planning Matrix

c)

ER Model

16.

Detailed, the well-planned development process

a)

Data Gathering

b)

Prototyping

c)

SDLC

17.

A cursory attempt at conceptual data modeling

a)

Data Gathering

b)

Prototyping

c)

SDLC

18.

Software tools providing automated support for systems development

a)

CASE

b)

MySQL

c)

Oracle

19.

Model components that can be purchased, customized and assembled info full-scale data models

a)

Package Data Model

b)

Data Model

c)

Enterprise Data Model

20.

Which of these can be determined from business-function/data entity matrices

a)

External Schema

b)

Internal Schema

c)

Conceptual Schema

21.

In this schema diagrams and ER-models are described.

a)

External Schema

b)

Internal Schema

c)

Conceptual Schema

22.

Logical & Physical structure is well defined in this schema

a)

Internal Schema

b)

External Schema

c)

Conceptual Schema

23.

What statement that defines or constrain some aspect of the business

a)

Cardinality

b)

Business Rule

c)

Relationship

24.

Which of these are NOT characteristics of a good business rule

a)

Redundant

b)

Precise

c)

Declarative

25.

Which of these is a good characteristic of a business rule

a)

Consistent

b)

Redundant

c)

Inexpressible

26.

This is understood by business people

a)

Business Oriented

b)

Business Rule

c)

Business Guide

27.

Which of these is NOT an example of a good Data Name?

a)

Readable

b)

Technique

c)

Unique

28.

This is a word or phrase with a specific meaning:

a)

Term

b)

Fact

c)

Data Name

29.

This is the association between two or more terms:

a)

Fact

b)

Term

c)

Data Name

30.

What database term is defined as a person, people, palace, object or event?

a)

Entity

b)

Cardinality

c)

Relation

31.

What rule states that any foreign key value must match a primary key value in the relation of the one side?

a)

Referential Integrity

b)

Overlapping

c)

Disjoint

32.

What kind of business rule is comes from another knowledge, often in the form of a formula using attribute values?

a)

Derivation

b)

Assertion

c)

Action Assertion

33.

Set of one or more entity types and associated relationships grouped into a single abstract entity type is called _______

a)

Subtype

b)

Supertype

c)

Entity Cluster

34.

What is an example of a composite attribute whose subparts pertain to different subtypes? Each subpart contains a Boolean value to indicate whether or not the instance belongs to the associated subtype.

a)

Disjoint

b)

Overlapping

c)

Clustering

35.

Which of these is a simple attribute with alternative values to indicate the possible subtypes

a)

Discriminator

b)

Overlapping

c)

Disjoint

36.

Which rule expresses a static structure includes attributes, relationships, and definitions

a)

Structural Assertion

b)

Action Assertion

c)

Assertion

37.

These are identifiers that enable a dependent relation to refer to its parent relation

a)

Enterprise Key

b)

Primary Key

c)

Foreign Key

38.

Which of the following is the unique identifier of the relation?

a)

Primary Key

b)

Foreign Key

c)

Enterprise Key

39.

What is a two-dimensional table of data that consists of rows (records) and columns (attribute or field)

a)

Relationship

b)

Relation

c)

Entity

40.

What kind of rule express constraints/control of organizational actions

a)

Derivation

b)

Structural Assertion

c)

Action Assertion

41.

What attribute of the supertype determine the target subtypes

a)

Disjoint

b)

Discriminator

c)

Clustering

42.

What is a process of defining a more general entity from a set of more specialized entity types?

a)

Generalization

b)

Specialization

c)

Total

43.

What is a process of defining one or more subtypes of the supertype and forming a supertype/subtype relationships

a)

Generalization

b)

Specialization

c)

Partial

44.

Which of these generic entity type has a relationship with one or more subtypes

a)

Supertype

b)

Subtype

c)

Subgrouping

45.

Whether an instance of a supertype must also be a member of at least one subtype

a)

Disjointness

b)

Completeness

c)

Overlapping

46.

What is the instance of a subtype and also an instance of the supertype?

a)

Overlap

b)

Disjoint

c)

Discriminator

47.

Whether an instance of a supertype may simultaneously be a member of two (or more) supertype

a)

Overlapping

b)

Completeness

c)

Disjointness

48.

An instance of the supertype can be only one of the subtypes

a)

Disjointness

b)

Completeness

c)

Overlapping

49.

What kind of subgrouping of entities in an entity type has attributes distinct from those in other subgroupings?

a)

Subtype

b)

Supertype

c)

Disjoint

50.

An instance of the supertype could be more than one of the subtypes

a)

Overlap

b)

Disjoint

c)

Discriminator