Test I

Question 1

The _______ key of the _______ becomes the _______ key of the many

Answer 1

Primary key; one; foreign key

Question 2

What are the five management principles

Answer 2

Mobilize
Translate
Align
Motivate
Govern

Question 3

In terms of management, what is vision

Answer 3

Where an organization is desired to be in the future (typically five years)

Question 4

What are strategic objectives

Answer 4

Strategic objectives are the ways/processes that a company will use to achieve its vision

Question 5

What are key performance indicators

Answer 5

KPIs are key measures that are used to quantify a company’s progress towards its vision

Question 6

What are two key types of metrics

Answer 6

Lagging indicators
Leading indicators

Question 7

What kind of indicators/results are based on past actions that are usually too late to adjust to

Answer 7

Lagging indicators

Question 8

What kind of indicators/results are based on current results and can influence future actions

Answer 8

Leading indicators

Question 9

If you measure _________, you measure _________

Answer 9

Everything; nothing

Question 10

Evaluation strategies

Single loop learning: ________ good and ________ bad

Double loop learning: _________ good and _______ bad

Answer 10

Strategy good and execution bad; execution good strategy bad

Question 11

What are the five main perspectives of the balanced scorecard

Answer 11

Mission
Fiduciary
Customer
Internal Perspectives
Learning and growth

Question 12

Of the five main perspectives, which one is a leading indicator

Answer 12

Learning and growth

Question 13

What is realized strategy

Answer 13

A blend of proactive initiatives and reactive responses in an organization’s typical strategy

Question 14

What does deliberate strategy revolve around

Answer 14

Proactive elements
Planned initiatives
‘Happy path’

Question 15

What does emergent strategy revolve around

Answer 15

Reactive elements
Responses to unanticipated developments
Developed on the fly

Question 16

What is a business process

Answer 16

A collection of linked tasks that once completed will accomplish an organizational goal

Question 17

What does DCOVA stand for

Answer 17

Define
Collect
Organize
Visualize
Analyze

Question 18

What does D in DCOVA stand for

Answer 18

Define what you need to measure

Question 19

What does C in DCOVA stand for

Answer 19

Collect: Locate the data

Question 20

What does O in DCOVA stand for

Answer 20

Organize: Extract data and create databases for it

Question 21

What does V in DCOVA stand for

Answer 21

Visualize: Create reports

Question 22

What does A in DCOVA stand for

Answer 22

Analyze: Answer questions

Question 23

What is an entity

Answer 23

A person, place, or thing an individual wants to collect data about

Question 24

What is a variable

Answer 24

A characteristic of an entity

Question 25

If a variable is unknown, it’s value is stored as ________

Answer 25

NULL

Question 26

What are two major types of variables

Answer 26

Categorical variables Numerical variables

Question 27

___________ variables are qualitative Numerical variables are __________

Answer 27

Categorical variables; quantitative

Question 28

What are two types of quantitative variables

Answer 28

Discrete Continuous

Question 29

What is a domain

Answer 29

A set of values from which one or more fields draw their actual values Eg. Car type -Sedan -SUV -Compact

Question 30

What do domain integrity constraints require

Answer 30

Values must be part of the domain

Question 31

What is cardinality

Answer 31

The number of unique values in a domain

Question 32

What is are examples of low cardinality and high cardinality

Answer 32

Low cardinality: car engine type -Petrol -Electric -Hydrogen -Solar High cardinality: car brands -BMW -Mercedes -Audi -Porsche -Toyota -Nissan -Honda -Ferrari -Citroen -Dodge -Mazda -Chevy -Mitsubishi …

Question 33

What is a record

Answer 33

A set of field values that represent instances of an entity Eg. rows in excel or real databases

Question 34

What are keys

Answer 34

Unique identifiers of an instance of an entity

Question 35

What are three types of keys

Answer 35

Primary Key Foreign Key Surrogate Key

Question 36

How is a foreign key created

Answer 36

A primary key from one table is added to another table to form a relationship between the two tables

Question 37

What is a surrogate key

Answer 37

A system-generated key

Question 38

What is a table

Answer 38

A two-dimensional structure of rows and columns

Question 39

(Yes or False) In a heap, the order of rows is important

Answer 39

False, the order of rows in a heap is not important

Question 40

(True or false) Order of columns in a table is important

Answer 40

False, order of columns in a table is not important

Question 41

What is a resolution to ‘many-to-many’ entity relationships

Answer 41

Intersection tables