BCIS

Databases and Excel Chapter 6

A decision support system accumulates all information relevant to running a business and makes it readily available to whoever needs to make business decisions.  

False

Data is stored in a database in Fields, Records, and Text boxes.

False

Referential integrity ensures that the data contained in a database is accurate and reliable. 

False

Data validation is the process of ensuring that data entered into a field meets specified guidelines.

True

Which is not one of the three common field properties that help define data?

Election value

A ____________________ is a field in a table that uniquely identifies a record.

primary key

Transaction-processing systems are used by retail stores to collect data about the transaction taking place.

True

Object query language is designed to manipulate or extract data from a database.

True

Which is the most popular type of database?

Relational

A data storehouse is a large-scale collection of data that contains and organizes all the data from the organization's multiple databases in one place.

False

Goal Seek is a what-if analysis tool.

True

Goal Seek has the ability to restrict variables to integers and greater than zero numbers.

False

Which of these characters is not an acceptable character to use in a range name?

!

The number of scenarios that Scenario Manager can manage is unlimited.

False

Which is not true about Scenario Manager?

It is rarely used in business models.