Deck 2: Database Concepts and Applications in Human Resource Information Systems

Question 1

A ________ allows you to ask a question based on one or more tables in a database.

A)action query
B)question query
C)cross-tab query
D)select query

Answer 1

D

Question 2

HR metrics are:

A)various measures of organizational performance
B)derived from organizational data
C)improve organizational efficiency and effectiveness
D)All of the above

Answer 2

D

Question 3

The employee's name is an example of:

A)an entity
B)an attribute
C)an object
D)a primary key

Answer 3

B

Question 4

A data warehouse is a special type of database that is optimized for reporting and analysis and is the raw material for management's decision support system.

Question 5

MS Access would be appropriate for an organization that:

A)had a small database and limited knowledge of database programming
B)had a small database and extensive knowledge of database programming
C)had a large database and limited knowledge of database programming
D)had a large database and extensive knowledge of database programming

Question 6

One of the benefits of a relational database systems is that:

A)end users who generally had limited programming experience can still utilize the query functionality.
B)organizations can easily implement them.
C)they are easy to maintain.
D)they are a strategic HRM resource

Question 7

Information is the ________ of data while knowledge is information that has been given ________.

A)accumulation, structure
B)meaning, structure
C)interpretation, meaning
D)understanding, definitions

Question 8

Data mining involves visually analyzing large data sets to identify recurring relationships.

Question 9

Functional units, management levels, and geographically dispersed locations may all have the need to:

A)share data
B)limit attributes in the database
C)reduce database needs
D)limit query functionality

Question 10

The advent of the Internet and a standardized communication protocol have contributed to:

A)easier database programming
B)data sharing across geographically dispersed locations
C)the maximization of query functionality
D)the elimination of a centralized database

Question 11

Which of the following is NOT a shortcoming of early file-oriented database structures?

A)data redundancy
B)poor data control
C)inadequate data manipulation capabilities
D)inability to resemble manual record keeping

Question 12

Patterns in large data sets are identified through:

A)the creation of tables
B)data gathering
C)data mining
D)electronic data storage

Question 13

A shortcoming of hierarchical and network database systems was that:

A)only very knowledgeable technical staff members could interact with the database effectively
B)relationships between records were explicitly maintained
C)it replaced file-oriented structures
D)it was electronically stored data

Question 14

Business intelligence (BI)applications include:

A)the activities of decision support systems
B)query and reporting
C)forecasting
D)all of the above

Question 15

Data processing systems that performed record-keeping functions that mimicked existing manual procedures were called:

A)file-oriented data structures
B)small database structures
C)data warehouses
D)electronic data storage

Question 16

_________________ is a broad category of business applications and technologies for creating data warehouses and for analyzing and providing access to these specialized data to help enterprise users make better business decisions.

A)Strategic planning
B)Business intelligence
C)Enterprise solution
D)Data intelligence

Question 17

The database design process:

A)begins with determining what the users want
B)is a task that only upper management should manage
C)begins with a budget estimate
D)requires outside consultant services

Question 18

When a(n)________ from one table is stored as an attribute of another table, that attribute is called a _______.

A)primary key, foreign key
B)object, entity
C)foreign key, primary key
D)entity, attribution

Question 19

Queries are important because:

A)they are a way to store data
B)they provide direction for strategic HR
C)they provide answers to questions about the data stored in a database
D)allow you to manipulate information

Question 20

An attribute is a characteristic of the entity in a relational database.

Question 21

Relational database data is stored in tables where each table represents one 'entity' in the real world and the information associated with that 'entity' is stored only in that table.Tables are related to each other through a common attribute or key.

Question 22

The database design process begins with determining what the users want.

Question 23

Transaction processing systems are business applications that focus on processing operational data.

Question 24

One of the benefits of a relational database systems is that end users who generally had limited programming experience can still utilize the query functionality.

Question 25

A foreign key represents the primary key from another table that is stored as an attribute in another table.

Question 26

What is meant by business intelligence?

Question 27

The employee's name is an example of an object.

Question 28

What are some examples how an organization might use the data sharing ability of a relational database system?

Question 29

MS Access would be appropriate for an organization that had a small database and limited knowledge of database programming.

Question 30

Tables are used to store information about entities.Multiple tables are created for each entity.

Question 31

What were the benefits of relational database systems versus traditional file-oriented data structures?

Question 32

A field is an attribute of a entity that is stored in a table.

Question 33

What is meant by a cross-tab query?

Question 34

The advent of the Internet and a standardized communication protocol have contributed to easier database programming.

Question 35

Compare the typical users of an action query with those of a cross-tab query.

Question 36

What are decision support systems and what role do they play?

Question 37

A database is a permanent, self-descriptive store of interrelated data items that can be processed by only one business application.

Question 38

Entities include only physical but not conceptual items.

Question 39

Provide some examples of actions that might be performed as a result of an action query.

Question 40

What are the implications for databases and information sharing in today's global environment?

Question 41

What critical role does N-tier architecture provide to large, multinational companies?

Question 42

What is meant by a hierarchical database?