Deck 11: Behind the Scenes: Databases and Information Systems

Question 1

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.

A) integrity
B) redundancy
C) completeness
D) normalization

Answer 1

B

Question 2

Data in a multidimensional database is organized in a ________ format.

A) linear
B) modular
C) cube
D) cellular

Answer 2

C

Question 3

A(n)________ check determines whether a required field such as LastName was filled in.

A) completeness
B) range
C) consistency
D) alphabetic

Answer 3

A

Question 4

A ________ check would be used to restrict the fines for speeding violations from $50 to $250.

A) completeness
B) range
C) consistency
D) numeric

Question 5

A(n)________ is a way of retrieving information from one or more tables that defines a particular subset of data.

A) validation rule
B) field constraint
C) enquiry
D) query

Question 6

Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data.

A) enterprise
B) structured
C) unstructured
D) multidimensional

Question 7

In a database, a group of related records is referred to as a(n)________.

A) memo
B) field
C) object
D) table

Question 8

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n)________ field.

A) text
B) long text
C) short text
D) object

Question 9

Which of the following is NOT a likely primary key?

A) Driver's license number
B) Date of birth
C) Student ID number
D) Social Security number

Question 10

Data ________ ensures that the data contained in a database is accurate and reliable.

A) efficiency
B) integrity
C) redundancy
D) consistency

Question 11

A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.

A) many-to-one
B) one-to-many
C) one-to-one
D) many-to-many

Question 12

A ________ check compares the values of data in two or more fields to see whether those values are reasonable.

A) correctness
B) range
C) consistency
D) numeric

Question 13

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.

A) Referential integrity
B) Normalization
C) Database consistency
D) Record integrity

Question 14

You would use a ________ to temporarily display records of residents of the city of Boston.

A) sieve
B) filter
C) validation rule
D) field constraint

Question 15

In a database, the term ________ is synonymous with a category of information.

A) field
B) record
C) row
D) table

Question 16

A ________ is a group of related data that can be stored, sorted, organized, and queried.

A) database
B) spreadsheet
C) memo
D) macro

Question 17

________ databases are the most frequently used electronic databases.

A) Relational
B) Flat-file
C) Multidimensional
D) Object-oriented

Question 18

You can set a ________, which is automatically displayed in a field unless the user enters something different.

A) default value
B) relation
C) field type
D) numeric check

Question 19

Data ________ helps to ensure data integrity by maintaining information in only one place.

A) flexibility
B) redundancy
C) mapping
D) centralization

Question 20

________ is used to ensure that data is organized most efficiently.

A) Consistency checking
B) Validation
C) Normalization
D) Range checking

Question 21

In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing.

A) direct
B) batch
C) real-time
D) immediate

Question 22

Management information systems (MIS)provide reports called ________ reports, which show conditions that are unusual or need attention from users of the system.

A) detail
B) summary
C) exception
D) expert

Question 23

In a database, another term for a table is a(n)________.

Question 24

When working with a relational database, each record must have a(n)________ key field, which has a value unique to that record.

Question 25

In a relational database, a(n)________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

Question 26

________ is the branch of computer science that attempts to create computers that think like humans.

A) Natural language processing
B) Expert systems
C) Artificial intelligence
D) Enterprise resource planning

Question 27

A group of related records is called a(n)________.

Question 28

Referential integrity means that for each value in the ________ field of a table, there is a corresponding value in the primary key of the related table.

Question 29

Data staging consists of all of the following steps, EXCEPT ________.

A) transforming the data
B) mining the data
C) storing the data in a warehouse
D) extracting the data

Question 30

A(n)________ is designed to improve communications and help employees complete their routine tasks.

A) office support system (OSS)
B) transaction-processing system (TPS)
C) management information system (MIS)
D) decision support system (DSS)

Question 31

________ databases are better at handling unstructured data such as audio clips, video clips, and pictures.

Question 32

________ involves putting data into an electronic file in a format that another application can recognize.

A) Exporting
B) Importing
C) Enhancing
D) Extracting

Question 33

A data ________ is a large-scale electronic repository of data that contains and organizes all of an organization's data in one place.

A) mart
B) chain
C) warehouse
D) storehouse

Question 34

A database that allows data to be maintained in a single location provides data ________.

Question 35

A(n)________ database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables.

Question 36

The Siri personal assistant application on Apple's iPhone 5s is an example of a ________.

A) natural language processing (NLP) system
B) decision support system (DSS)
C) management information system (MIS)
D) database management system (DBMS)

Question 37

Data that describe other data are called________.

Question 38

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.

A) Boolean algebra
B) relational algebra
C) primary keys
D) foreign keys

Question 39

A ________ displays a subset of data from a table (or tables)based on the specified criteria.

A) table query
B) join query
C) select query
D) criteria query

Question 40

In a Microsoft Access database, an active web page, email address or existing file is stored as a(n)________ field.

Question 41

Employees' last names would usually make an appropriate primary-key field.

Question 42

Data redundancy ensures that the data contained in the database is accurate and reliable.

Question 43

A large data mart might require a database administrator to design, construct, and maintain it.

Question 44

A(n)________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

Question 45

A field ________ is a property that must be met before an entry can be accepted into the field.

Question 46

To temporarily display records from a single table that match certain criteria, you would use a(n)________.

Question 47

A(n)________ is created from a large data business warehouse to analyze a single component of the business.

Question 48

When using Access, the text of the Gettysburg Address would be stored in a short text field.

Question 49

________ is used to analyze large amounts of data and identify unseen patterns or trends.

Question 50

A(n)________ tries to replicate the decision-making processes of human experts to solve specific problems.

Question 51

The data in a data warehouse are ________, meaning they do not all pertain to one period in time.

Question 52

When using SQL, a(n)________ query is used to extract data from two or more tables.

Question 53

A business that updates its records all at once at the end of the business day uses ________ processing.

Question 54

A group of related records is called a table.

Question 55

When creating a data warehouse, ________ is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

Question 56

A data dictionary is also referred to as a(n)________.

Question 57

A(n)________ report provides a consolidated picture of detailed data and usually includes some calculation or visual displays of information.

Question 58

An employee's ID number, name, company position, address, city, state, and Zip Code make up a record.

Question 59

________ data are information about how users of a company's website move through the web pages.

Question 60

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

Question 61

A database schema defines the name, data type, and length of each field in the database.

Question 62

Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.

Question 63

Normalization means that there are no data entry errors in a database.

Question 64

Most databases can import electronic data from other software applications.

Question 65

A last name field is an example of a field that should have a default value.

Question 66

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.

Question 67

A filter is limited to extracting data from a single table.

Question 68

Real-time processing means that transactions are updated when they occur.

Question 69

The information in a data mart spans an entire enterprise.

Question 70

A summary report provides a list of the transactions that occurred during a specified time period.