Question 1

HR metrics are
A) various measures of organizational performance
B) derived from organizational outcomes
C) used to improve organizational efficiency and effectiveness
D) all of these

Accepted Answer

HR metrics are various measures of organizational performance that are derived from organizational outcomes. They are used to improve organizational efficiency and effectiveness by measuring employee performance, workforce demographics, turnover rates, and other key factors. Therefore, all the given options are correct, and the answer should be D.

Question 2

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

Accepted Answer

Information is the interpretation of data, and knowledge is information that has been given meaning.

Question 3

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

Accepted Answer

MS Access is a relational database management system that is easy to use, making it appropriate for organizations with small databases and limited knowledge of database programming. It allows users to create tables, forms, queries, and reports without requiring extensive programming knowledge. For larger databases or more complex needs, a more robust database system might be more appropriate.

Question 4

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

Accepted Answer

Hierarchical and network database systems required technical expertise to interact with the database effectively, limiting access to a broader range of users.

Question 5

When a(n)______ from one table is stored as an attribute of another table,that attribute is called a(n)______.
A) primary key; foreign key
B) object; entity
C) foreign key; primary key
D) entity; attribution

Accepted Answer

When a primary key from one table is stored as an attribute of another table, that attribute is called a foreign key. This establishes a relationship between the two tables.

Question 6

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

Accepted Answer

The database design process begins with determining what the users want in order to ensure that the final product meets their needs and expectations. This is typically done through requirements gathering sessions and discussions with key stakeholders. Upper management may be involved in the process, but it is not solely their responsibility. Budget estimates and outside consultants may also be necessary, but they typically come later in the process.

Question 7

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

Accepted Answer

Data mining involves using computer algorithms and statistical techniques to analyze large data sets and identify patterns and relationships that may not be immediately visible. While visualization can be a useful tool in data mining, it is not the primary method of analysis.

Question 8

A(n)______ 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

Accepted Answer

A select query is used to ask a question or retrieve data based on one or more tables in a database. It allows you to select specific fields to be displayed, apply filters, and even join multiple tables together. Action queries are used to modify data, cross-tab queries are used to summarize data in a table format, and question query is not a valid term in database query language.

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

Accepted Answer

Sharing data is a common need among diverse functional units, management levels, and geographically dispersed locations. Having access to the same information and data is essential for collaboration, decision-making, and achieving organizational goals. Therefore, providing a centralized and accessible database is crucial for meeting this need. Limiting attributes, reducing database needs, or limiting query functionality, on the other hand, would not be helpful in addressing the need for data sharing.

Question 10

Queries are important because
A) they are a way to store data
B) they provide direction for strategic HR
C) they allow you to present questions to the DBMS in a language it understands
D) they allow you to manipulate information

Accepted Answer

Queries allow you to present questions to the DBMS in a language it understands, known as SQL (Structured Query Language), to retrieve, filter, and sort data from a database. They do not store data or provide direction for strategic HR, although they are a tool for manipulating information.

Question 11

Business intelligence (BI)applications include ______.
A) the activities of decision support systems
B) query and reporting
C) forecasting
D) all of these

Accepted Answer

Business intelligence (BI) includes activities such as decision support systems, query and reporting, and forecasting. Therefore, option D, "all of these," is the best choice.

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

Accepted Answer

Patterns in large data sets are identified through data mining. Data mining is the process of analyzing data from different perspectives and summarizing it into useful information. It involves identifying patterns, correlations, and anomalies in data sets to provide insights and make informed decisions. The other options (creating tables, data gathering, and electronic data storage) are important components of data analysis, but alone they cannot identify patterns in large data sets.

Question 13

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

Accepted Answer

The advent of the Internet and a standardized communication protocol have made it possible to share data across geographically dispersed locations, allowing for easier collaboration and access to information. While it has also contributed to other advancements in database programming and query functionality, the primary impact has been on the ability to share data. The elimination of a centralized database is not necessarily a direct result of the Internet and communication protocol, but more of a trend towards distributed databases.

Question 14

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 recordkeeping

Accepted Answer

Inability to resemble manual recordkeeping is not a recognized shortcoming of early file-oriented database structures. The other options are all known drawbacks of early file-oriented database structures.

Question 15

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

Accepted Answer

This statement is true as an attribute is a characteristic or property of an entity in a relational database. For example, a customer entity in a database may have attributes such as name, address, phone number, and email address.

Question 16

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.

Accepted Answer

A data warehouse is designed to support business intelligence activities, such as data analysis, data mining, and reporting. It is structured for easy querying and analysis and is a critical component of an organization's decision support system.

Question 17

One of the benefits of a relational database system 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

Accepted Answer

Relational database systems provide a user-friendly query interface that allows non-technical users to easily retrieve and analyze data. This makes it easier for organizations to use the database system to make informed decisions. While B and C are also benefits of relational database systems, D is not a benefit.

Question 18

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

Accepted Answer

The term "file-oriented" refers to a style of data processing that replicates traditional paper-based record-keeping systems. This type of system typically uses flat files to store data, with each file representing a specific type of record, such as a customer or a purchase order. File-oriented systems are still used today in some industries, but they are less common than they were in the past.

Question 19

The employee's name is an example of ______.
A) an entity
B) an attribute
C) an object
D) a primary key

Accepted Answer

The employee's name is an attribute, which describes a characteristic or property of an entity (in this case, the employee). An entity is a person, place, thing, or concept that is represented in a database, and an object is a specific instance of an entity. A primary key is a unique identifier for each record in a table, such as an employee ID number.

Question 20

______ 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

Accepted Answer

Business intelligence is the broad category of business applications and technologies for creating data warehouses and analyzing and providing access to specialized data to help enterprise users make better business decisions. Therefore, option B is the best choice. The other options, strategic planning (A), enterprise solution (C), and data intelligence (D), do not accurately describe this category of applications and technologies.

Quiz 2: Database Concepts and Applications in HRIS

HR metrics are

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

MS Access would be appropriate for an organization that

A shortcoming of hierarchical and network database systems was that

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

The database design process

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

A(n) ______ allows you to ask a question based on one or more tables in a database.

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

Queries are important because

Business intelligence (BI) applications include ______.

Patterns in large data sets are identified through ______.

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

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

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

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.

One of the benefits of a relational database system is that

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

The employee's name is an example of ______.

______ 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.

Quiz 2: Database Concepts and Applications in HRIS

HR metrics are

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

MS Access would be appropriate for an organization that

A shortcoming of hierarchical and network database systems was that

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

The database design process

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

A(n) ______ allows you to ask a question based on one or more tables in a database.

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

Queries are important because

Business intelligence (BI) applications include ______.

Patterns in large data sets are identified through ______.

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

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

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

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.

One of the benefits of a relational database system is that

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

The employee's name is an example of ______.

______ 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.

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

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