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

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

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

Free
(Multiple Choice)
4.9/5
(40)
Correct Answer:
Verified

D

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.

Free
(True/False)
4.8/5
(39)
Correct Answer:
Verified

True

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

Free
(Essay)
4.8/5
(41)
Correct Answer:
Verified

In today's global environment, access to data from any physical location in the world is increasingly important.Computer networks are created that provide instant access to these operational data, allowing real-time managerial decision capability regardless of physical location. A centralized database allows a company to confine its data to a single location and, therefore, more easily control data integrity, updating, backup, query, and control access to the database.A company with many locations and telecommuters, however, must develop a communications infrastructure to facilitate data sharing over a wide geographical area.The advent of the Internet and a standardized communication protocol made the centralized database structures and geographically dispersed data sharing feasible.

MS Access would be appropriate for an organization that:

(Multiple Choice)
4.8/5
(40)

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

(Multiple Choice)
4.9/5
(44)

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

(True/False)
4.9/5
(37)

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

(Multiple Choice)
4.8/5
(39)

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

(Essay)
4.8/5
(35)

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

(Multiple Choice)
4.8/5
(40)

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

(Multiple Choice)
4.9/5
(41)

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

(True/False)
4.9/5
(42)

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

(Essay)
4.8/5
(41)

Patterns in large data sets are identified through:

(Multiple Choice)
4.8/5
(38)

What is meant by a cross-tab query?

(Essay)
5.0/5
(44)

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

(Essay)
4.9/5
(44)

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

(Multiple Choice)
4.8/5
(33)

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

(Essay)
5.0/5
(38)

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.

(True/False)
4.9/5
(42)

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

(True/False)
4.8/5
(30)

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

(True/False)
4.8/5
(39)
Showing 1 - 20 of 42
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)